main logo
Subject: Re: how to make emtpy cursor for add or importing
Author: Robert Nichols
Posted: 2001/01/31 11:50:42
 
View Entire Thread
New Search


on 1/30/01 3:11 PM, Erik Mueller-Harder at lists /at/ praxisworks D.O.T com wrote:

>> I want to produce an empty cursor for importing text into, or at other
>> time, for adding a new record to via code.
>>
>> I tried selecting for recid = 0,
>
> That's correct. You should end up with a zero-record cursor, with no
> database errors.
>
>> but that didn't accept the import.
>
> What do you mean? Are you getting a Valentina error? At what stage?

Doh! I spoke too soon. I had expected to see the cursors record count
reflect the imorted records, and it didn't. But I see the records found
their way into the base object nonetheless. Sorry to assumed trouble before
investigating further.

Robert
> Your code should look something like:
>
> - select statement ("select * from myBO where recID = 0")
> - assignment statements
> - cursor Add function
>
> depending on what language you're working with. In REALbasic:
>
> vc = new VCursor(myDB, "select * from myBO where recID = 0")
> vc.StringFIeld(1).value = "some sample text"
> vc.Add
>
> Do you definitely have a writeable cursor? You can't yet write a cursor
> that's built on more than one base object.
>
> Hope this helps,
>
> Erik
> ______________________________________________________________________
> Erik D. Mueller-Harder, Editor Praxis News Digest
> http://pnd.praxisworks.com/
>
> -------------------------------------------------------------
> The Valentina mailing list is brought to you by MacServe.net
> For info on lists services, see http://www.macserve.net/lists.html


-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2001 Robert Nichols
<-- Prior Message New Search Next Message -->