Recent content by edwinjs

No. Each Department is provided with a Printer.

Create temp table in the main procedure with ## (Global) and try it out.

Preview works fine so does other reports and prints too. Only this 1 report doesnt print but i can preview and even export to text file.

Its just a simple report with Arial font. No Graphics or anything.

One of my Quick Report in my application does not print in certain computers. Other reports print and even word & excel is printing. Just this 1 report is not printing on few computers, but it prints on my computer.

In Delphi 7 Quick Report package (dclQrt70.bpl) has to be manually added.

UPDATE table SET Office = CASE WHEN Department = 'SE' THEN 'ANR' ELSE 'BRU' END WHERE Department in ('SE','AI')

http://bdn.borland.com/article/images/29106/ migrating_bde_applications_to_dbexpress.pdf

Steven is 100% Right. Unless you change the logic to suit Client / Server, performance will suffer and some times the application hangs. I had this problem (5 years back) of changing paradox to SQL Server. More over BDE is no more supported by Borland either ADO / DBExpress is the way to go...

Well, You should avoid using table components while using SQL Server instead use TQuery with "where" clause to restrict data and you logic will change substancially while converting it to Client / Server. Unless you do that you will have perfomance degradation. One more thing !! why...

I have little access knowledge. But I think you link SQL Server Tables to your Access Database and the data will still remain in SQL Server and all your forms and view can use the linked tables and views.

obislavu, Your solution works for 1 LotID

I still think there is a much simpler way to do this.

SELECT A.* From (SELECT WorkOrderLot.LotID, TravelerLot.TravLotID, Process.ProcNum FROM TravelerLot INNER JOIN WorkOrderLot ON TravelerLot.LotID = WorkOrderLot.LotID INNER JOIN Process ON TravelerLot.CurrentProcID = Process.ProcessID) A Inner Join (SELECT...

1. ASP.NET & MS SQL Server 2000 2. PHP & MySQL