Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PK via INSERT INTO .. FROM MEMVAR
Message
From
04/08/1998 15:03:22
 
 
To
04/08/1998 14:57:01
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00123882
Message ID:
00123885
Views:
14
>Can I use the INSERT INTO .. FROM MEMVAR and
>get the proper next primary key as employed in the
>Tastrade app? The nextid routine works via the
>INSERT INTO .. VALUES but not from MEMVAR.
>The uniqueness of the PK is violated that way. I prefer
>the FROM MEMVAR technique but will have to try
>something else unless there is a workaround...

It doesn't matter how you insert a record, but it matters what values you are going to use. I believe, that Tastrade uses PK-generated stored procedure value as default, and doesn't include this field in INSERT .... VALUES() list. I guess you can imitate the same thing with MEMVAR but you will have to specify that primary key field will not be included in the list.
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform