Home > Archive > Clarion > August 2007 > Urgent!! Help!! Data cannot be written to Database!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Urgent!! Help!! Data cannot be written to Database!!
|
|
| steventohsk@gmail.com 2007-08-21, 3:55 am |
| Dear all,
I have a very strange problem. Hope to get some light from you.
I have an application writing data to a MS SQL database. The data
seems to be committed to the database as I can retrieve the data from
my application after entering it.
However, after I exit from my application and re-login to it, the data
that I have just written was gone!!!!
I use an SQL statement to query the database directly and the data is
NOT there too.
Strange!!! I could use retrieve the data before i exit out of the
application.
Anyone knows why?
Any help would be much appreciated.
Thanks.
Steven Toh
Singapore.
| |
| steventohsk@gmail.com 2007-08-21, 3:55 am |
| hi,
to add on, i am using a Win XP with SQL Server 2000.
I am connecting to the database via ODBC.
On Aug 21, 11:41 am, stevento...@gmail.com wrote:
> Dear all,
> I have a very strange problem. Hope to get some light from you.
> I have an application writing data to a MS SQL database. The data
> seems to be committed to the database as I can retrieve the data from
> my application after entering it.
> However, after I exit from my application and re-login to it, the data
> that I have just written was gone!!!!
> I use an SQL statement to query the database directly and the data is
> NOT there too.
> Strange!!! I could use retrieve the data before i exit out of the
> application.
> Anyone knows why?
>
> Any help would be much appreciated.
> Thanks.
>
> Steven Toh
> Singapore.
| |
|
| On Aug 20, 8:41 pm, stevento...@gmail.com wrote:
> Dear all,
> I have a very strange problem. Hope to get some light from you.
> I have an application writing data to a MS SQL database. The data
> seems to be committed to the database as I can retrieve the data from
> my application after entering it.
> However, after I exit from my application and re-login to it, the data
> that I have just written was gone!!!!
> I use an SQL statement to query the database directly and the data is
> NOT there too.
> Strange!!! I could use retrieve the data before i exit out of the
> application.
> Anyone knows why?
>
> Any help would be much appreciated.
> Thanks.
>
> Steven Toh
> Singapore.
Try to check the trigger and relation of your Table. I've same
experience with You and it's solved by modify the trigger and check
again your source again.
Thank's
|
|
|
|
|