...pp,printers ps, posdetail pd,posheader ph,userse u
where ph.transact=pd.transact and ph.userid=u.id and pd.prodnum=p.prodnum and p.prodnum*=pp.prodnum and pp.portid*=sp.portid and
sp.printerid=ps.id and ps.connectedtostation=1 and pd.transact=135 order by pd.uniqueid asc
the database...
...pp,printers ps, posdetail pd,posheader ph,userse u
where ph.transact=pd.transact and ph.userid=u.id and pd.prodnum=p.prodnum and p.prodnum*=pp.prodnum and pp.portid*=sp.portid and
sp.printerid=ps.id and ps.connectedtostation=1 and pd.transact=135 order by pd.uniqueid asc
the database...
BIM pos is the key. www.bimsolutions.biz
they have a very beautiful, robust and user friendly system as well as constructive management back office modules.
It's been a long time that I am out of town,I don't know if you have done it already.
Since you have the installation CD of sybase, try reinstalling sybase on the win2k server. make a shortcut of the engine with the previous parameters and DB path. and load the engine again.
I guess that the sybase database on the server is crashed.
try rebuilding the database.
and bytheway if the problem still persists (which i doubt) you may play with the server page size it would increase database performance too.
Sybase is free with some minor restrictions on linux operating systems.
You can ask for adaptive server 12.5 or install it from www.sybase.com
for the difference there always have to be adaptation on the new language that you get to know. it's all about time.
you can know the table comlumns from the system tables that are hidden in the database.
To see all the table names check the SYSTABLE and to see the columns in any table check the SYSCOLUMN table.
Dear friend the only solution is that there's a problem with the network.
Can you tell me what is the engine paramaters that you are using to run the database on the server?
what network protocols are you using, netbeu, tcpip and if you have enough licenses to run as many clients as you want?
...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 all units where have a link with 'Each' like:
Each-Pack*2pc-Box*8Pck
and if i choose Kg...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.