General information
Category:
Coding, syntax & commands
>>>>>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.
>>>
>>>Guess I don't know how to exclude just one field from a MEMVAR list. That
>>>is why I am having the trouble I am having...
>>
>>You could call your GetNextPrimaryKey Function and store it to you m.PrimaryKey right before your Insert Into ... From Memvar
>>
>>HTH
>
>That approach would work, but not the way I'd like it to work.
>I am setting the nextid function as the default value in table designer...
Try
scatter memvar memo fields except pk_fieldname
and then
insert into ...... from memvar
Sarosh
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only