U++ framework
Do not panic. Ask here before giving up.

Home » U++ Library support » U++ SQL » SqlArray Join
Re: SqlArray Join [message #8450 is a reply to message #4117] Sat, 10 March 2007 18:44 Go to previous messageGo to previous message
forlano is currently offline  forlano
Messages: 1244
Registered: March 2006
Location: Italy
Senior Contributor
rbmatt wrote on Sat, 22 July 2006 07:42

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?


Hello,

I was unable to compile the package with 2007.1.rc2.
Perhaps something changed during these months. Any hope to fix it? I remind I was able to compile it with old version. Now all the complains come from the .sch file.

Luigi
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: ODBC ?
Next Topic: MS SQL Server connection possible?
Goto Forum:
  


Current Time: Tue Sep 08 19:13:37 GMT+2 2026

Total time taken to generate the page: 0.01109 seconds