Prev: Database growing, performance degrading...
Next: SQL 2000
From: LUIS on 27 Jun 2008 12:01
I want to watch a Invoice layout before saving and printing (like "Print
Preview" option). What is "best"?
-To save registers in regular tables and delete them if are not definitive,
or
-To create temporary tables to do so, or
- ?

Beforehand, thank
--
Luis Garcia
IT Consultant
From: John Bell on 28 Jun 2008 03:00

"LUIS" <LUIS(a)discussions.microsoft.com> wrote in message
news:1EC61B85-8F45-46C2-8E35-1AA44C27B78D(a)microsoft.com...
>I want to watch a Invoice layout before saving and printing (like "Print
> Preview" option). What is "best"?
> -To save registers in regular tables and delete them if are not
> definitive,
> or
> -To create temporary tables to do so, or
> - ?
>
> Beforehand, thank
> --
> Luis Garcia
> IT Consultant

Hi

This would really depend on the functionality of your front end, The data
will have already been retrieved from the database and you can work with it
in memory. If you are actually looking for a print queue that persists if
the user aborts the application or between sessions, then a permanent table
would be the way to go.

John

 | 
Pages: 1
Prev: Database growing, performance degrading...
Next: SQL 2000