U++ forum: Welcome to the forum

Re: SqlArray Join [message #4117 is a reply to message #4115]

Sat, 22 July 2006 07:42

rbmatt
Messages: 90
Registered: July 2006
Location: Tennesse, USA

Member

Ok, so I worked through several things today.
I added schema support so while in debug mode it will update my schema based on the .sch file. Then I use sch to automatically define all my SqlId's.
I found out why I was having a problem with data reverting to old states. Got that (mostly) fixed.
I don't think there is a way for me to manually make the changes to the database (short of actually writing the code Wink

). What I mean is UpdateRow() is protected so I cannot call it. There are no member functions that say "write this to the db" that I see.
Also inserting does not seem to be working. I traced the code as best I could.
The program does a late insert but somehow it looks like it only wants to do an update. The update code looks like:
update CUSTOMERS set NAME = 'test', ADDRESS = NULL, CSZ = NULL, PHONE1 = NULL, NAME = 'test' where ID is NULL
Well, there is no entry where ID is NULL so nothing happens.
And to get the autonumber we need to set ID = NULL which it does not do.
I've attached my new version.
Thanks.
P.S. What are the lines in the DocEdit? Is there a way to turn that off?

Attachment: EzellApp4_v2.zip
(Size: 3.51KB, Downloaded 1823 times)

Report message to a moderator