16 May 20:05
Load Record Error - V11
From: Jason Hect <jhect@...>
Subject: Load Record Error - V11
Newsgroups: gmane.comp.lang.inug-4d.tech
Date: 2008-05-16 18:08:08 GMT
Subject: Load Record Error - V11
Newsgroups: gmane.comp.lang.inug-4d.tech
Date: 2008-05-16 18:08:08 GMT
This will work OK in 4D 2004, but the Load Record command causes an error in V11. It's actually just the last 2 lines that cause the problem, I'm just creating a record so I can delete it. :) CREATE RECORD([Test_Data]) SAVE RECORD([Test_Data]) DELETE RECORD([Test_Data]) LOAD RECORD([Test_Data]) Where I run into this problem is when changing read write access to a table. I have a method to control this, which unloads any records, changes read write access, and then reloads the record. In my code I do something like this: Query([Test_Data];[Test_Data]ID=123)`Find a record D_Access(True;->[Test_Data]) `Call method to get read write access to table DELETE RECORD([Test_Data]) D_Access(False;->[Test_Data]) `Call method to set read only access to table, which will unload record, change access, and reload causing error. I guess I need to experiment some more, but do I no longer need to unload the current record in V11 before changing table read write access? Thanks, Jason ********************************************************************** The 4D v11 SQL Roadshow - coming to a city near you! http://www.4D.com/roadshow/index.html(Continue reading)
HTH
Alex
>
> I have need to do the following:
>
> I need to load a web form (from a site over which I have NO CONTROL)
> from
> within my 4D system, and populate some of the forms variables with
> data from
> my 4D system. Then, when the user completes the forms and submits
> it, I
> need to capture all the data entry back into my system.
>
RSS Feed