V4RB Addrecords

[Charles Cohen]

On 10/23/09 1:02 AM, "Charles Cohen" <rwc1717 at shaw.ca> wrote:

 > Other happenings..
 > If I delete the database and run the application....it errs by not  
recognizing
 > the preference table that I use when app.open code is executed...
 > rsOpen = Nil
 > rsOpen = mDb.SQLSelect("select * from  
Choices","EVCursorLocation.kClentside)

 >>Wait a moment!

 >>You use this cursor to add record?

 >>ClientSide cursor is always READ ONLY.

In this case I am only reading the cursor not adding a record in this  
case...
I read this value and if there is nothing....I then open a Serverside  
cursor to Add the record to this table
the 'create' database should have created the empty table...but as I  
said no tables exist in the new database

 >>You need specify ServerSide


 > vException is...on the SQLSelect
 > it should have created an empty database...but throws the log error

 > Table ( or view) is not found:  sys_Diagrams

 >>This was produced by Vstudio, not by your app

 > Get View: No view with the name Equity.

 >>This is probably your app

 > The tables should have been made...the .vdb file exists but nothing  
in it.

The above was just a test to see if I was creating a new  
database...and I am not...hence the error.

Also....

This does not address the problem with being able to only update and  
remove existing records..
when I use the existing database...as I said...no log errors...no  
exception...but no new record with Addrecord

This is the same effect as when I try and add a new record to any  
table in the existing database.

Thanks
Harry & Chuck



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20091023/0a25e53f/attachment.html