Executing a bath file from form load() 1

[load3d]

I want to run the batch file if the version on my SQL server is different than the version on my local table. Here is my code: (It's not working)

If Dlookup("Version", "localversion") <> "Dlookup("Version, "SQLversion") then

call shell("C:\program files\Maintenance\Update.bat", VBNORMALFOCUS, 1)

else

end sub


When my form loads nothing happens. Help?

 

[PWise]

If Dlookup("Version", "localversion") <> [COLOR=red]"[/color]Dlookup("Version, "SQLversion") then 

call shell("C:\program files\Maintenance\Update.bat", VBNORMALFOCUS, 1) 

else 

end sub

take out extra quotes

 

[PHV]

Replace this:
If Dlookup("Version", "localversion") <> "Dlookup("Version, "SQLversion") then
With this:
If Dlookup("Version", "localversion") <> Dlookup("Version", "SQLversion") Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[load3d]

Done. Thanks man.