Run lib\Update on company table ver 8.03 408A

I found the problem. When I was linking my userfile to company table I used
no-lock in the link. The system will update all the other table records
except for the date field. When I remove the no-lock it update the date
field fine.

Thanks for the response!

Steve


-----Original Message-----
From: Brian W. Spolarich [mailto:bspolarich@...]
Sent: Friday, February 26, 2010 9:23 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run lib\Update on company table ver 8.03 408A




Maybe try using the NOW function instead of TODAY?

Can you update it with a real date?

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@advanced <mailto:bspolarich%40advancedphotonix.com>
photonix.com ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of vantage03
Sent: Friday, February 26, 2010 9:03 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] Run lib\Update on company table ver 8.03 408A

I am trying to run Run lib\UpdateTableBuffer.p(input BUFFER
Company:HANDLE,'Date01',today). on the company table with no luck. I am able
to run Run lib\UpdateTableBuffer.p(input BUFFER
Company:HANDLE,'CheckBox01',true). or even change an integer file, but can
not get the any of the date fields to change in the company table. Is anyone
actually changing the date in the company table?

see any thing wrong with my string Run lib\UpdateTableBuffer.p(input BUFFER
Company:HANDLE,'Date01',today). ?

Steve

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto: http://groups.
<http://groups.yahoo.com/group/vantage/files/.>
yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.
<http://groups.yahoo.com/group/vantage/messages>
yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups. <http://groups.yahoo.com/group/vantage/linksYahoo>
yahoo.com/group/vantage/linksYahoo! Groups Links







[Non-text portions of this message have been removed]
I am trying to run Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'Date01',today). on the company table with no luck. I am able to run Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'CheckBox01',true). or even change an integer file, but can not get the any of the date fields to change in the company table. Is anyone actually changing the date in the company table?

see any thing wrong with my string Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'Date01',today). ?

Steve
Maybe try using the NOW function instead of TODAY?

Can you update it with a real date?

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of vantage03
Sent: Friday, February 26, 2010 9:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run lib\Update on company table ver 8.03 408A

I am trying to run Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'Date01',today). on the company table with no luck. I am able to run Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'CheckBox01',true). or even change an integer file, but can not get the any of the date fields to change in the company table. Is anyone actually changing the date in the company table?

see any thing wrong with my string Run lib\UpdateTableBuffer.p(input BUFFER Company:HANDLE,'Date01',today). ?

Steve






------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links