Search results for query: *

Dear friends: I have the following case that I am requiring the convenient SQL to access the data.(It's been more than 3 days working) I am using Sybase 5.5.5, I have tried many many SQL statements that sometimes run right, sometimes wrong (which is very weird!). my sql statement is: select...

Dear friends: I have the following case that I am requiring the convenient SQL to access the data.(It's been more than 3 days working) I am using Sybase 5.5.5, I have tried many many SQL statements that sometimes run right, sometimes wrong (which is very weird!). my sql statement is: select...

Guys do u know where can i get the "BIM pos" from? I have heard that it is a great system. John Vai

Dear Friends: I have this case and i don't know if there's a solution for it. I have the following units table ID NAME SUBUNIT CONVERSION 1 Kg 1 1 2 Ton 1 1000 3 Each 3 1 4 Pack*2pc 3 2 5 Box*8Pck 4 8 I want to get...

How can i show the Printers form from CR so that the user trying to print a report can direct the report to a specific printer? CR 8.5 any help?

I cannot export from my compiled program to excel from the CR 8.5. I can export at design time from CR but when compiling it to VB cannot export from the exe file. Any missing dlls or properties? Any thoughts? John

Dear Friends: I have this error message when updating from VB6. "Table or view not found:correlation name 'Products' not found." The trigger is on posdetail table after insert event. the trigger code is: alter trigger "dba".Poller after insert order 1 on "DBA".POSDETAIL referencing new as...

Dear Friends: juat a question about how can i install within my VB program the sybase client program with all its files and put them in my package? any suggestion?

Dear Friends: I have a question, which i am not sure if it works in sql. i have member names in a table with their number of orders field. MEMBERS ------- ID MEMNAME NUMOFDEL I want to show the first 50 members having the maximum number of orders (NUMOFDEL) grouped as well by MEMNAME or ID...

Dear Friends: I would like te ask you about this error. ***Assertion failed error and then my database goes crashed and can't recover. any help? thanks

Dear Friends: I have a question, which i am not sure if it works in sql. i have member names in a table with their number of orders field. MEMBERS ------- ID MEMNAME NUMOFDEL I want to show the first 50 members having the maximum number of orders (NUMOFDEL) grouped as well by MEMNAME or ID...

Dear Friends: I think that the problem i am having is coming by opening from ASA6.0 a database made by ASA5.0? How can I upgrade my database or fix the problem? Any hints?

Dear friends: I am converting from 5.0 to 6.0 and using VB 6 as application. I get as errors: 1-ERROR assertion failed Memory allocation size too large 2-Disconnecting shared memory client, process id not found I am using in my application the connection strng...

Dear friends: I have tried a lot using the reload and load commands from sybase. I am using the sybase 5. I have a used database, which means i have records in it. I want a new virgin database with the same structure, so that i can start with for other clients. but the problem is that i need...

Dear friends: I have tried a lot using the reload and load commands from crystal. I am using the crystal 5. I have a used database, which means i have records in it. I want a new virgin database with the same structure, so that i can start with for other clients. but the problem is that i need...

Dear Friends: I just want to ask you this question: I have two tables: one is sales table called {Posheader} and the second {Tax}. the fileds are: POSHEADER --------- transact 1 |2 |3 Amount 1650 |1500 |3300 Tax1 150 |0 |300 TAX --- Tax1 10 //10% value Tax2 0...

Dear Friends: I have 2 tables having the following fields: Stations Printers ---------------- ------------------- Statnum 1 | 2 ID 1 | 2 | 3 Printer1 1 | 0 Type 56| 43| 12 Printer2 2 | 1 Port 2 | 1 |...

Dear Friends: I work in VB6 and i have connected it to sybase database. I wanna have some tips and hints on how can i perform my reports in speed (I want to have the report generated in very small amount of time, when the user asks for it.) Thanks in advance, John

Dear friends: I have 2 tables (Members and Membercontacts). membercontacts.memberid is referenced bt members.id I want to display the members.memname, membercontacts.contactname, membercontacts.contactdetails where members.id=4 i cannot make any join that will display me a result containing at...

Dear friends: I have 2 tables (Members and Membercontacts). membercontacts.memberid is referenced bt members.id I want to display the members.memname, membercontacts.contactname, membercontacts.contactdetails where members.id=4 i cannot make any join that will display me a result containing at...