Recent content by Phyllis

Hi Marco, I was able to isolate the problem further and you might not need the sample application at all. The problem occurs when the dataset that we were inserting into has a "DefaultExpression" defined for one of the fields. Our OnApplyRecord method is not returning a row id, so when the...

Have you gotten the file yet, Marco? If not, will you please check your spam folder or give me some other way to get it to you? We have an upgrade project that is pretty much on hold for an answer for this and we have to have a solution soon so we can move on. Thank you.

I just tried re-sending again, this time I renamed the zip file to .zi~. Hopefully that will allow it to reach you.

Did you get the sample this time, Marco? And if not, will you check to see if for some reason a spam filter caught it? Not that it should sound like spam at all, but with the attached zip file. . .

I just resent the message. Please let me know whether you receive it or not. Thanks!

Did you receive the sample, Marco? I haven't heard anything back at all. Could you give an estimate on when I might expect a response? Thank you!

I just sent off a sample app to you...

This is certainly happening on this dataset, which is the master for 4 others. They are all set up in the exact same way, with row_id and OnApplyRecord. As I mentioned before, this is happening after the insert and on the Refresh part of the statement, which I am not handling, because I simply...

Do you have any suggestions on how I can get around this in my situation? I need to give immediate feedback to my users when they try to create a child record that is invalid, and the code lives in the database in the insert procedure called in OnApplyRecord. So if I wait to call...

Hi Marco, Here is the select statement. I have others that are similar which cause the same problem, all have the rowid. . . SELECT lan.ROWID, lan.lan_no, lan_geo_no, lan_lns_no, lan_name, lan_studio_priority_bool, lan_alternate_lan_no, lan_comments, lan_list_bool...

I'm getting an error when trying to apply updates to an inserted record. The error is "A lock refresh or check cannot be performed without a rowid. Provide a rowid in the query or handle this action in the OnApplyRecord event." My query does use a rowid. My properties for the component are...

OK. Thanks, Marco.

Thank you, Marco. That does solve my problem for the most part. I am curious, though, as to why calling ApplyUpdates doesn't tell the dataset that they have been applied. In my case, when the user created a child record, they had the option of doing more edits or creating more children which...

I am attempting to use the TOracleDataSet's OnApplyRecord method to call stored procedures for DML statements, but am having trouble. Using the latest version of DOA, with the CachedUpdates of my TOracleDataSet = True and also when I have it = False, when I insert a record and call...

I didn't realize that there was a help item on the Oracle menu. That will be useful. When I try to get to the help files, I get a message telling me that the format is not valid. Here is the message: "The Help for this program was created in Windows Help format, which depends on a feature...