As I said, if I try to save to a single table (ie:products) , there is
no problem.
FYI, I use a cursor adapter derived from a statement like this:
'select * from products where 1=0' this will produce an empty CA. I
then append a record, fill the corresponding data for the new item and
save it with tableupdate.
I do the same, but using transactions, with the invoice. Each table to
be saved has a separate cursor adapter, a record (or series of records
in the case of the invoice child table) is appended and then all CA's,
one by one, are saved using tableupdate, in the manner suggested in the
Hackers guide.
I have been using this approach for years with no problems.
But this works very well if the app is run from the server (where the
SQL Server Express resides) but fails in the case of the transactions
(there are several screens with this problem, such as invoices,
purchases, stock adjustments, etc) All of these fail if run from the
local machine, but not from the server. A single save, not involving
begin transaction does not fail.
Weird
Rafael
El 22/09/2014 18:44, Tracy Pearson escribió:
Rafael Copquin wrote on 2014-09-22:
I have an app that uses SQL SERVER EXPRESS 2008 R2 as external motor.
The SQL server resides in a Windows 7 Prof box, acting as a server for 3
other Windows 7 Home boxes
I can connect from the HOME pc to the Prof server and my app can read
data from the SQL Server
I can save new records from the HOME pc to the SQL engine, using cursor
adapters, provided they are a single table.
From the Server computer I can save a series of tables within a
transaction, also using cursor adapters, with no problem (ie: invoice,
consisting of a header, a child and several other tables, such as stock,
accounts receivable, value added tax collected, etc)
However, using the same app from the Windows 7 Home boxes, I can't save
the invoice. The error I get states that the data types do not match.
I repeat, the same app run from the server works flawlessly, but run
from the other pc's gives that error.
Please advise
Rafael Copquin
Rafael,
Are you able to save any data in that configuration? Or is it just this
process?
Tracy Pearson
PowerChurch Software
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
