dbTalk Databases Forums  

Bad Time spec

comp.databases.paradox comp.databases.paradox


Discuss Bad Time spec in the comp.databases.paradox forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Craig
 
Posts: n/a

Default Bad Time spec - 09-28-2007 , 03:36 AM






P10 SP3
I have a form which has the following code in the init method:

if formatExist("hh:mm:ss am") then
formatSetTimeDefault("hh:mm:ss am")
else
msgInfo("Status", "Requested format does not exist.")
endIf

There are two indentical tables:
ReferringLetter.db
LettersSent.db
In a daughter form I have code which does the following:

In ReferringLetter.db, a field called TimeField which is a "Time" field has
the time a letter was sent. The time is inserted via a TCursor:
letterTC.Timefield = Time()

Then the same daughter form copies the record from ReferringLetter.db to
LettersSent.db :
PermTC.copyRecord(LetterTC)
Each time I get the following error:
Bad Hour Specification >>>invalid character.: "N"

The second table was created by copying the first table and the fields, of
course, are exactly the same.
And if I manually do Tools > Utility> Add
I don't have a problem. It adds nicely.
Obviously, I am missing something.
Thanks in advance,

Craig




Reply With Quote
  #2  
Old   
Craig
 
Posts: n/a

Default Re: Bad Time spec - 09-28-2007 , 02:08 PM






Nevermind.
I figured it out.
The code was fine. It was TCursor pointing to the wrong table.
I feel like an idiot.
Oh well...nothing new.
More questions, I sure will come.
Thanks,

Craig


"Craig" <craig.futterman (AT) nospam (DOT) comcast.net> wrote

Quote:
P10 SP3
I have a form which has the following code in the init method:

if formatExist("hh:mm:ss am") then
formatSetTimeDefault("hh:mm:ss am")
else
msgInfo("Status", "Requested format does not exist.")
endIf

There are two indentical tables:
ReferringLetter.db
LettersSent.db
In a daughter form I have code which does the following:

In ReferringLetter.db, a field called TimeField which is a "Time" field
has the time a letter was sent. The time is inserted via a TCursor:
letterTC.Timefield = Time()

Then the same daughter form copies the record from ReferringLetter.db to
LettersSent.db :
PermTC.copyRecord(LetterTC)
Each time I get the following error:
Bad Hour Specification >>>invalid character.: "N"

The second table was created by copying the first table and the fields, of
course, are exactly the same.
And if I manually do Tools > Utility> Add
I don't have a problem. It adds nicely.
Obviously, I am missing something.
Thanks in advance,

Craig






Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.