Search results for query: *

Just install last version of MDAC TLGsoft "If it works, don't fix it"

In ODBC, set your connection to TCP/IP. TLGsoft "If it works, don't fix it"

BTW, even Personal Edition have replication... TLGsoft "If it works, don't fix it"

You said Decimal / Decimal. See SQLBill's post. Maybe this will help you: cast(0.01 as decimal) = 0 cast(0.01 as decimal(9,1)) = 0 cast(0.01 as decimal(9,2)) = 0.01 TLGsoft "If it works, don't fix it"

osjohnm, tell that to sp_mergesubscriptioncleanup. Always when I try to clean up my replication, it remains a lot of system tables, stored procs and views that you can't delete because they are system owned. So, I delete them directly from sysobjects, and it works.

Run this in QA: SELECT @@version if buildno is 780 then you have SP3 5xx then you have SP2 lower then you have SP1

forget about sysobjects, Jymm is right. It's a Foreign Key problem and you can edit that in table properties

use DaysBetween() from DATEUTILS unit

do a PRINT @mystr to see what are you trying to execute

sysobjects table contains the reference

First set the &quot;Allow modifications directly ...&quot; option in SQLServer properties. update sysobjects set UID = a.IDNumber from (select UID as IDNumber from sysusers where [name]='dbo') as a where UID <> a.IDNumber

use SP_EXECUTESQL()

ExtractFileName()

The problem was NULL. SQL does scalling automatically. He just could say MyRealValue = 0. Even MyStringValue = 0 (not '0')

Syntax is: MyValue IS NULL, not MyValue <> NULL

Check the local datetime values (Control Panel). 26 Feb 2003 = 26.02.2003 or 02.26.2003 (both true, but in different system locales)

yes, of course you can write Use AssignFile(), Rewrite(), Writeln(), CloseFile() to write information into a file. Or, if you have the information into, let's say a memo, do a memo.SaveToFile or any file function of your component. to send a file to printer : WinExec('copy c:\myfile.txt...

Here's an ideea to reduce risks almost to 0: - use 2 separate servers Let's say Server1 192.168.99.1 Server2 192.168.99.2 - set up a continuous replication between them. - set connection to all users through TCP/IP for Server1 If your Server1 crashes, then you just...

Yep, it won't work, but he got the ideea.

If you are using a matrix printer, then you must want to print text. Write that text to a file, then send the file to the printer. example:&quot;C:\myfile.txt&quot; ----------------- INVOICE ----------------------------- Customer : Microsoft Address : Redmont, USA Payment method ...