The tblPalmStats table does not seem to be synchronizing on my iPaq. I have gone back through and checked this table several time in the list of tables to sync. After I do this and try to sync this table becomes unchecked again.
Also, when I choose the tables I want to sync I am getting the following error in the error log:
Tuesday, December 17, 2002 9:53:11 PM, User: default, synchronization started.
Database: NCSoftware
option: 1 - Overwrite existing tables
option: 1 - Keep this database synchronized
Tuesday, December 17, 2002 9:54:05 PM, Database transfer begun.
Copying table PDAAircraft
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAAircraft.
SQL: SELECT `AircraftID`,`Aircraft`,`Category`,`Class`,`RatingCategory`,`CharacteristicsPower`,`CharacteristicsType`,`RatingClass`,`TypeRatingReq`,`Description`,`Complex`,`HighPerformance`,`Over12500`,`Retractable`,`Simulator`,`Tailwheel`,`CostPerHour`,`TimeEntered`,`Correction` FROM `PDAAircraft`
Copying of 10 record(s) completed.
Copying table PDACertificates
Processing indexes:
Index processing has been stopped. There are no more indexes available.
3 index(es) were successfully created.
Computing checksums for table PDACertificates.
SQL: SELECT `CertificateID`,`Grade`,`Number`,`DateIssue`,`Remarks` FROM `PDACertificates`
Copying of 0 record(s) completed.
Copying table PDACustom
Processing indexes:
Index processing has been stopped. There are no more indexes available.
1 index(es) were successfully created.
Computing checksums for table PDACustom.
SQL: SELECT `CustID`,`Custom1`,`Custom2`,`Custom3`,`Custom4`,`Custom5`,`Custom6`,`Custom7`,`Custom8`,`Custom9`,`Custom10`,`Field1`,`Field2`,`Field3`,`Field4`,`Field5`,`Field6`,`Field7`,`Field8`,`Field9`,`Field10`,`Expense1`,`Expense2`,`Expense3`,`Expense4`,`Expense5`,`Expense6`,`Expense7`,`Expense8`,`Expense9`,`Expense10`,`Counter1`,`Counter2`,`Counter3`,`Counter4`,`Counter5`,`Counter6`,`Counter7`,`Counter8`,`Counter9`,`Counter10`,`txtText1`,`txtText2`,`txtText3`,`txtText4`,`txtText5`,`txtText6`,`txtText7`,`txtText8`,`txtText9`,`txtText10` FROM `PDACustom`
Copying of 1 record(s) completed.
Copying table PDADupTimes
Processing indexes:
Index processing has been stopped. There are no more indexes available.
1 index(es) were successfully created.
Computing checksums for table PDADupTimes.
SQL: SELECT `AutoDupID`,`Aircraft`,`SELand`,`SESea`,`MELand`,`Helo`,`Glider`,`Custom1`,`Custom2`,`Custom3`,`Custom4`,`Custom5`,`Custom6`,`Custom7`,`Custom8`,`Custom9`,`Custom10`,`Night`,`Instrument`,`XC`,`Solo`,`PIC`,`SIC`,`Dual`,`Instructor`,`SEFE`,`Autofill`,`Sim`,`Landing`,`Option1`,`Option2`,`Option3`,`Option4`,`Option5`,`Option6`,`Option7`,`Option8`,`Option9`,`Option10`,`counter1`,`counter2`,`counter3`,`counter4`,`counter5`,`counter6`,`counter7`,`counter8`,`counter9`,`counter10` FROM `PDADupTimes`
Copying of 3 record(s) completed.
Copying table PDAEventExpiration
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAEventExpiration.
SQL: SELECT `expireitemid`,`event`,`period`,`eom` FROM `PDAEventExpiration`
Copying of 4 record(s) completed.
Copying table PDAHistory
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAHistory.
SQL: SELECT `HistoryID`,`Category`,`Date`,`Remarks`,`DateDue`,`DaysTillDue`,`EOM` FROM `PDAHistory`
Copying of 0 record(s) completed.
Copying table PDALogbook
Also, when I choose the tables I want to sync I am getting the following error in the error log:
Tuesday, December 17, 2002 9:53:11 PM, User: default, synchronization started.
Database: NCSoftware
option: 1 - Overwrite existing tables
option: 1 - Keep this database synchronized
Tuesday, December 17, 2002 9:54:05 PM, Database transfer begun.
Copying table PDAAircraft
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAAircraft.
SQL: SELECT `AircraftID`,`Aircraft`,`Category`,`Class`,`RatingCategory`,`CharacteristicsPower`,`CharacteristicsType`,`RatingClass`,`TypeRatingReq`,`Description`,`Complex`,`HighPerformance`,`Over12500`,`Retractable`,`Simulator`,`Tailwheel`,`CostPerHour`,`TimeEntered`,`Correction` FROM `PDAAircraft`
Copying of 10 record(s) completed.
Copying table PDACertificates
Processing indexes:
Index processing has been stopped. There are no more indexes available.
3 index(es) were successfully created.
Computing checksums for table PDACertificates.
SQL: SELECT `CertificateID`,`Grade`,`Number`,`DateIssue`,`Remarks` FROM `PDACertificates`
Copying of 0 record(s) completed.
Copying table PDACustom
Processing indexes:
Index processing has been stopped. There are no more indexes available.
1 index(es) were successfully created.
Computing checksums for table PDACustom.
SQL: SELECT `CustID`,`Custom1`,`Custom2`,`Custom3`,`Custom4`,`Custom5`,`Custom6`,`Custom7`,`Custom8`,`Custom9`,`Custom10`,`Field1`,`Field2`,`Field3`,`Field4`,`Field5`,`Field6`,`Field7`,`Field8`,`Field9`,`Field10`,`Expense1`,`Expense2`,`Expense3`,`Expense4`,`Expense5`,`Expense6`,`Expense7`,`Expense8`,`Expense9`,`Expense10`,`Counter1`,`Counter2`,`Counter3`,`Counter4`,`Counter5`,`Counter6`,`Counter7`,`Counter8`,`Counter9`,`Counter10`,`txtText1`,`txtText2`,`txtText3`,`txtText4`,`txtText5`,`txtText6`,`txtText7`,`txtText8`,`txtText9`,`txtText10` FROM `PDACustom`
Copying of 1 record(s) completed.
Copying table PDADupTimes
Processing indexes:
Index processing has been stopped. There are no more indexes available.
1 index(es) were successfully created.
Computing checksums for table PDADupTimes.
SQL: SELECT `AutoDupID`,`Aircraft`,`SELand`,`SESea`,`MELand`,`Helo`,`Glider`,`Custom1`,`Custom2`,`Custom3`,`Custom4`,`Custom5`,`Custom6`,`Custom7`,`Custom8`,`Custom9`,`Custom10`,`Night`,`Instrument`,`XC`,`Solo`,`PIC`,`SIC`,`Dual`,`Instructor`,`SEFE`,`Autofill`,`Sim`,`Landing`,`Option1`,`Option2`,`Option3`,`Option4`,`Option5`,`Option6`,`Option7`,`Option8`,`Option9`,`Option10`,`counter1`,`counter2`,`counter3`,`counter4`,`counter5`,`counter6`,`counter7`,`counter8`,`counter9`,`counter10` FROM `PDADupTimes`
Copying of 3 record(s) completed.
Copying table PDAEventExpiration
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAEventExpiration.
SQL: SELECT `expireitemid`,`event`,`period`,`eom` FROM `PDAEventExpiration`
Copying of 4 record(s) completed.
Copying table PDAHistory
Processing indexes:
Index processing has been stopped. There are no more indexes available.
2 index(es) were successfully created.
Computing checksums for table PDAHistory.
SQL: SELECT `HistoryID`,`Category`,`Date`,`Remarks`,`DateDue`,`DaysTillDue`,`EOM` FROM `PDAHistory`
Copying of 0 record(s) completed.
Copying table PDALogbook