Hi everybody,
I've been pluggin' away at a little application that uses a small
realSQL db, plus tuning one that I had built a short time ago, and have
run into some issues.
With the new one, built inside 2006 R3, I have it make a test db when
the application opens, and give it a table. This is the table create
statement:
res = dbases(0).createTable("test(id integer auto_increment, thisName
text, primary key(id))")
Oh, and I suppose I should let you all know that I'm using an array of
classes called dbstrut, and that the createTable function contains this:
sqlString = "create table " + sqlString
mydb.SQLExecute(sqlString)
if mydb.Error Then
MsgBox mydb.ErrorMessage
Return False
end if
if not mydb.Error Then
Return True
end if
So, that seems, to me, to be ok. No problems so far. Now I populate that
table with:
dim sample As DatabaseRecord
sample = new DatabaseRecord
sample.Column("thisName") = "Fargo"
dbases(0).createRecord("test", sample)
And the thisName column does in fact display this result when I query
it, but id is never incremented. If I add id to the DatabaseRecord and
initialize it, I can see it fine.
My older application runs, but simply fails to put any information into
the database. In R2 it still works fine. The newer app doesn't auto
increment in R2 either, so I'm completely baffled.
Any thoughts? Anyone else experience this sort of behavior?
Thanks,
Fargo
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
