Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Null nor not null columns
Message
From
09/06/2003 18:40:22
 
 
To
09/06/2003 18:11:20
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00798132
Message ID:
00798145
Views:
22
>Hi all
>
>I am using SQL Pass Through for all my data access to a sql database. I use the replace command to change the data and then roll my own update and insert statements. I just ran into an issue of trying to replace a column with null when none of the columns in the cursor are null. The column on the table does accept null. I can't find a way to set the column to accept nulls in this case. Is there a way? DBsetprop() won't work because I am not using a DBC.
>
>Thanks.

Hi James,

Are you saying that remote column defined as NULL defined as NOT NULL in local cursor? Could you provide complete repro code?
Take a look into message #790070 for a workaround.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform