Search results for query: *

how can i use ado to do store the image? can u please give me a quick example please? -gerard

I have a table in sql server 7 and a field is datatype of image. How do I insert / store an image in the table? -gerard

I have been searching the Sybase Online help and searched for union in v11.9.2 and under New Functionality in Adaptive Server Enterprise 11.9.2 it had an example: Statements involving the union operator, where the select statement on one side of the union references tables that reside on a...

I get this error: Msg 102, Level 15, State 1: Server 'SYBFAO_TRD2', Line 2: Incorrect syntax near 'FK_Advisor_Client_Reg_Advisor'. FOR: ALTER TABLE dbo.Advisor_Client_Reg ADD CONSTRAINT "FK_Advisor_Client_Reg_Advisor" FOREIGN KEY("ADVISOR_SEQ_NO") REFERENCES...

I did that but i get this message: Server 'SYBFAO_TRD2', Procedure 'dbo.TDA_ADVISOR', Line 5: DELETED not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output). so do i put DBP. in front of DELETED?

Hi all, I am new to ASE and ASA is different than ASE. I am using ASE 12.5 and I am trying to create a trigger. Foe example here's a trigger: CREATE trigger dbo.TDA_ADVISOR on dbo.Advisor for delete as begin declare @@iAdvisorSeqNo numeric(10) select @@iAdvisorSeqNo =...

My view name is DBA.QV_PUCHASE_DETAIL_HARD_SOFT_ACCT It works fine in my version of Sybase. But not my clients. So can u help me on this one?? -Gerry

I created views in Sybase ASE 12.5. However, when I tried to run the view script on another Sybase version (unknown) I get error messages saying, "The Identifier that starts with 'myViewName' is too long. Maximum length is 30" How do I fix this? Please- I need an answer ASAP. My...