S with MSSQL 6.5

S T Shea

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Using D3 C/S with MSSQL 6.5

Below error dialog message displayed when I posting data to the table:

==================================================
Information

access violation at 0x4be42b91: read of address 0x388b5708
83 34 00 74 63 E8 39 10 00 00 64 8B
==================================================

here is my code:

Table1.insert (or Table1.edit)
Table1['usr_id'] := edUserID.text;
Table2['usr_fullname'] := edUserName.text;
...
...
Table1.Post (The above dialog message displayed when the execution point up
to here.)

I don't get any error messages when I compile and run the program but the
annoying error
dialog consistently displayed when reached to the Table1.Post statement.

Any comments?????

Michel Santo

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Using D3 C/S with MSSQL 6.5

Here's a guess.

Run the program outside of Delphi's debugging mode; you know, by simply
double-clicking the program. Sometimes, the error message outside of the
de{*word*81} is better.

I had a similar problem when I upgraded a 16-bit app to D2 and D3 and was making
a hard-coded API reference to a 16-bit DLL.

I hope that this helps,

Michel

Quote

S T Sheak wrote:
> Below error dialog message displayed when I posting data to the table:

> ==================================================
> Information

> access violation at 0x4be42b91: read of address 0x388b5708
> 83 34 00 74 63 E8 39 10 00 00 64 8B
> ==================================================

> here is my code:

> Table1.insert (or Table1.edit)
> Table1['usr_id'] := edUserID.text;
> Table2['usr_fullname'] := edUserName.text;
> ...
> ...
> Table1.Post (The above dialog message displayed when the execution point up
> to here.)

> I don't get any error messages when I compile and run the program but the
> annoying error
> dialog consistently displayed when reached to the Table1.Post statement.

> Any comments?????

Dave

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Using D3 C/S with MSSQL 6.5

The general consessus is that TTables in an SQL environment are poison.
Instead of finding the solution to using a TTable component, I would suggest
that you explore using stored procedures on the server side to do your inserts
and updates. Ive been doing this for several months and have been quite happy
with the results.

example;

TStoredProc.ParamByName('usr_id').value := edUserID.text;
TStoredProc.ParamByName('usr_fullname').value := edUserName.text;
...
TStoredProc.ExecProc;

Dave

Quote

S T Sheak wrote:
> Below error dialog message displayed when I posting data to the table:

> ==================================================
> Information

> access violation at 0x4be42b91: read of address 0x388b5708
> 83 34 00 74 63 E8 39 10 00 00 64 8B
> ==================================================

> here is my code:

> Table1.insert (or Table1.edit)
> Table1['usr_id'] := edUserID.text;
> Table2['usr_fullname'] := edUserName.text;
> ...
> ...
> Table1.Post (The above dialog message displayed when the execution point up
> to here.)

> I don't get any error messages when I compile and run the program but the
> annoying error
> dialog consistently displayed when reached to the Table1.Post statement.

> Any comments?????

quar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Using D3 C/S with MSSQL 6.5

Try to use TQuery instead of TTable components. On SQLDataBases they work
better.

S T Sheak <sh...@dbix.com.my> scritto nell'articolo
<6q5uhn$6...@forums.borland.com>...

Quote

> Below error dialog message displayed when I posting data to the table:

> ==================================================
> Information

> access violation at 0x4be42b91: read of address 0x388b5708
> 83 34 00 74 63 E8 39 10 00 00 64 8B
> ==================================================

Other Threads

1. D3 With MsSql 6.5

2. 255 Character Limit - D3/MSSQL 6.5

3. Cancelling a long running query, D3, MSSQL 6.5

4. d3 c/s mssql 6.5 images into image field

5. HELP: D3 - MSSQL 6.5 - number of user connections.

6. MSSQL 6.5 ODBC, D3, TTables and Optimizer Hints

7. MS SS 6.0 to 6.5 and Text Memo Fields

8. IPicture : CS to SS

9. Date conversion using TQuery and MSSQL 6.5

10. using TEXT columns with MsSQL 6.5 and Delphi 2.0