Progress being made - need more help.

[Barry G. Sumpter]

This was to show how to pull your data in from a db record for optimistic
editing.

The next was going to show how to update but it looks like you've already
sorted it out.

 

 

From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Greg Olson-Hyde
Sent: Saturday, 12 September 2009 7:31 PM
To: Valentina Developers
Subject: Re: Progress being made - need more help.

 

Hi Barry,

 

Sorry to be so thick, but I just don't understand your code.

 

Greg

 

On 12/09/2009, at 5:24 PM, Barry G. Sumpter wrote:





 while vCurs.NextRecord_ODBC


   'intCntr = intCntr + 1
   'arrayList.AddRow cstr(intCntr) + ")  " + mRS.StringField(1).GetString +
mRS.StringField(2).GetString

   'msgbox vCurs.StringField(2).Name
   RecID = val(vCurs.StringField("RecID").getString)
   TabName =(vCurs.VarCharField("TabName").getString)
   Heading = (vCurs.VarCharField("Heading").getString)
   Prompt = (vCurs.VarCharField("Prompt").getString)
   Sequence = (vCurs.VarCharField("Sequence").getString)
   maxLength = (vCurs.VarCharField("maxLength").getString)
   Adjust = (vCurs.VarCharField("Adjust").getString)
   Bold = (vCurs.VarCharField("Bold").getString)
   MultiSelect = (vCurs.VarCharField("MultiSelect").getString)
   multiSelectPrompt = (vCurs.VarCharField("multiSelectPrompt").getString)

  ..... 

          'Do something
  .....
Wend



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Greg Olson-Hyde
Sent: Saturday, 12 September 2009 4:37 PM
To: Valentina Developers
Subject: Progress being made - need more help.

Hi All,

First up, thanks to everyone who has helped me so far. When attempting  
to compile my app using Valentina, I have managed to get the errors  
down from 747, to 157 - a great sense of satisfaction - due to the  
help offered by you all.

The next step for me is to understand how to deal with with the cursor  
regarding records. The following are what I use in SQLite but don't  
seem to have equivalents in Valentina:

RecordSet.Edit

RecordSet.InsertRecord

RecordSet.Commit - Is UpdateRecord the same as Commit?

>From what I have read Valentina does not deal with VCursor in the  
same way as SQLite deals with a RecordSet in RB - but I can't figure  
out how!

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090913/53cbfbfa/attachment.html