I am having trouble with RegistryReadKey not returning a value on windows 7, works on XP PRO

Newbie to SQL so any suggestions welcome DBconnect seems to work fine, I get a resault = 1 DBquery works fine on some remote machines, but others I get [MICROSOFT][ODBC - SQL Driver] Timeout expired not sure where to look THANKS!! LET>DD=TODAY DBConnect>Driver={SQL Server};Server=SQLSERVER2005\MASTE...

Found this litle peace of code of interest

USE master
EXEC sp_lock2

not sure how to use it yet, but kinda cool
Thanks for your help

New to databases, just using a simple dbconnect and dbexec. having a problem with an Update script if locked by another user. Looking for a way to see if table is locked befor doing update or a way to pass along the SQL error to the user or log. I am using macro Sched v12 with MS SQL 2005 I qet a qu...

Worked Great!!!!


I am assuming you can do the same thing with UPDATE.

THANKS!!!

I am unable to convert the following SQL script into a macro, I can modify fields fine but cannot seem to get the insert function to work. INSERT INTO ItemRecord (location,itemCode) values (0,00026600303167) DBConnect>Driver={SQL Server};Server=%SQL_SERVER%\ACS;Database=item;Uid=sa;Pwd=%PASS%;,dbH D...

THANKS!! Thats what happens when I over think things

I am trying to format a cost and retail dollar amount to 4 and 2 decimal places, this should be easy but my visual basic script blanks my two variable out and I get nothing. Any suggestions???? Let>retail=1.4 Let>cost=0.99 VBEval>FormatNumber(%retail%,2),retail VBEval>FormatNumber(%cost%,4),cost MDL...