FiveTech Software tech support forums

Tim You might want to try this simple suggestion and incorporate it into a function .. you might also add another couple of lines to see if empty(dDate) ??? Rick Lipkin dDate := Table->DateIf _ChkDate( dDate )Else    dDate := date()    // or a date of your choiceEndif//-----------...

Nages, This is what I am planning to revise database.prg's Load() method. I wouldn't advise automatically fixing data. Or at least not without logging every change to a record, perhaps by logging all the field data that was readable, and then the field that was changed and what it was changed to. Al...

I used your sample to first go through the database and replace each data field that returned an error with a default date. Then I ran the process and it did not error out. However, when I tried to run the process a 2nd time, I got a different error ... very strange one ... that had nothing to do wi...

Tim, I think you are going to have to do an ON ERROR trap and when it occurs replace the data with a valid date. James This is what I am planning to revise database.prg's Load() method. fwh 17.09      for n = 1 to Len( ::aBuffer )         TRY  &n...

1) Can you reproduce full error.log? That shows the value of n and from that we know which field is corrupted. 2) The sample I gave above works. You need to check the two date fields using the same logic. If run once it will rectify the total table 3) It is also possible that the calculated field is...

Tim,

I think you are going to have to do an ON ERROR trap and when it occurs replace the data with a valid date.

James

OK, let me try explaining this again. I am skipping through an existing database. It has this structure: VEHLIC  C  12  0        Vehicle licensePMSCOD  C  15  0        Labor codePMSDES  C  35  0      ...

USE <dbfname> EXCLUSIVEdo while !eof()   TRY      x := FIELD->dBaseD   CATCH      FIELD->dBaseD := STOD( "19800101" ) // default value   END   SKIPenddo  Another alternative is to open t...

I have a .dbf file. Three of the fields are type DATE. The file has had some corrupted values in it. As I skip through the database, sometimes the system will throw an error because one of the date fields values is somehow wrong. The error is ADSCDX 5095 : Cannot convert to a Juliene date. It sees t...

... char *address) { int count = 0; const char *c, *domain; static char *rfc822_specials = "()<>@,;:\\\"[]"; /* first we validate the name portion (name@domain) */ for (c = address; *c; c++) { if (*c == '\"' && (c == address || *(c - 1) == '.' || *(c - 1) ...

Dear All, It's been a while.. busy with FWH projects.. Anyone here who can authenticate/validate a logon from FW apps to Windows Active Directory? Kind regards, Frances Hi Fraxi, I found this VB script, transtale to Visual Basic on EXCEL, and tested Worked Fine. Private ...

VALID is not currently supported, so you have to validate the GET data yourself.

Please review QLineEdit() docs:

http://doc.qt.io/qt-4.8/qlineedit.html

... @Frances: if you are using a local SMTP server, then you probably don't need ssl. You could continue using fw Tsmtp class and validate username+password OR you could use CDO but first find out if your smtp server requires SSL connection and change "sendusing" value ...

... nKEy There is nothing about that in manual and only one line in xbrowse class One of all cases i need i if client press ENTER key to replace value validate it and if it is ok to go to next editable column I have try bKEyDown or bKeyChar ... but this is not going IF( EMPTY( KON ), { || EVAL( __Keyboard(CHR(13)) ...

... that i want if i press ENTER key (13) value of that column to be replaced with some value i have in array for that column. After that i want to validate valye of that column (entered or replaced) IF valid is ok go to next editable column ig no stay to that column and return value it was before ...