Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UPDATE - SQL Syntax
Message
From
21/02/2007 12:52:25
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01197658
Message ID:
01197678
Views:
15
Beats me! I used a Registry.h file (which I guess was needed by the class I use to read/write from the registry) and the first line in it is:

#DEFINE NULL chr(0)

I've removed it from the file and everything works now, but I need to see if that now affects anything else :(

>Yes, that cause the problem, but I wonder why you have #define NULL CHR(0) at all?
>
>
>>Thanks Carlos,
>>
>>I've come across a #DEFINE NULL chr(0) in an include file from a utility I use. This may be causing the problem!
>>
>>>Hello, there is nothing wrong with the sentences.
>>>
>>>They ran without any problem in vfp 9 sp1 and vfp 6.
>>>
>>>c.x.
>>>
>>>>Hi,
>>>>
>>>>I've got a mental block on this one. What is wrong with the following:
>>>>
>>>>
CREATE CURSOR c_edcards (edc_issued t null)
>>>>APPEND BLANK
>>>>UPDATE c_edcards;
>>>>	   SET edc_issued = NULL
>>>>
>>>>
>>>>I am getting an error:
>>>>
>>>>"Command is missing required clause"
Frank.

Frank Cazabon
Samaan Systems Ltd.
www.samaansystems.com
Previous
Reply
Map
View

Click here to load this message in the networking platform