Link to home
Start Free TrialLog in
Avatar of Venkat satya
Venkat satyaFlag for Singapore

asked on

Sybase - Insert/Update/Delete not working.

Hi ,


I am using sybase database for my project, for select queries its working fine but while insert/update/delete it's not working fine. Means app will become hang.


Please help me out.



User generated image



Thanks,
Venkat.
Avatar of Swatantra Bhargava
Swatantra Bhargava
Flag of India image

What error message you are getting?
Just checking, do you have Read only rights on the database or do you have Read/write permissions.
Kindly let us know how many records do you have on this table and whether you have any indexes available on id_n column or not.
Avatar of Venkat satya

ASKER

Thank you,

I have read/write permissions .Even some tables have less records( max 30 records) then, same problem just hang the app no exception printed, yes have an index on id_n column,

CREATE UNIQUE INDEX MISAS_MEAPS_Files ON marinedb.dbo.MISAS_MEAPS_Files (id_n) go;
Okay, try it some some other client and see whether it is a bug with respect to your client..
Try running it from command prompt with dbisql or dbisqlc commands and see whether it works or not.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.