Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: INSERT ... FROM NAME objectName
Message
From
06/04/2005 19:06:59
 
 
To
06/04/2005 18:37:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01001906
Message ID:
01002118
Views:
24
>>VFP have not a
>>
>> INSERT INTO table DEFAULT VALUES
>>
>>* APPEND BLANK don't support NULL ( a bug for me )
>>
>>Then i try to simulate it with a empty object
>>
>>On next code I expected no errors
>>
>>
>>#DEFINE DEFAULT_VALUES FROM NAME CREATEOBJECT("empty")
>>SET NULL ON
>>CREATE CURSOR byby (aa i,cc i)
>>* HELP: WITH objectName
>>* objectName == CREATEOBJECT("empty") no errors
>>
>>WITH CREATEOBJECT("empty")
>>ENDWITH
>>
>>* HELP: INSERT ... FROM NAME objectName
>>* objectName == CREATEOBJECT("empty") error
>>
>>INSERT INTO byby DEFAULT_VALUES
>>
>
>*This code errors:
>
>INSERT INTO byby FROM NAME CREATEOBJECT("empty")
>
>I'm not sure exactly what you're trying to to do.
>Can you add your defaults to your create cursor statement.

Try to do this with a SELECT INTO CURSOR !
Previous
Reply
Map
View

Click here to load this message in the networking platform