Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: INSERT ... FROM NAME objectName
Message
From
06/04/2005 18:37:11
 
 
To
06/04/2005 11:13:57
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:
01002114
Views:
16
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform