Search results for query: *

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

Some Sample data with structure of data would help

The problem was with Infopower TwwDBEdit Component. I changed it to TDBEdit and everything works fine. Lessons Learnt : Use 3rd party tools only when required. Sorry !!! I assumed TwwDBEdit = TDBEdit Thanks for the help anyway.

BDE has some restrictions while updating a Query with Joins. What i would suggest it Have a join Query as a Look-up and use Two Queries to Updated two tables based on the Selection from the look-up query.

Datatype in SQL Server is "Money" and i am using DBExpress with DatasetProvider and ClientDataset. In clientdataset, it is "TFMTBCDField".

I have a problem with DisplayFormat in Delphi7. I have set the DisplayFormat for a Numeric Field to #,###,##0.00. if i input 100.15 it becomes 100.00. I wonder why. I am using ClientDataset with SQL 2000 backend.