The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
DateTime Editor
Posted: 10 Apr 08 11:27 AM
|
I am still learning.... I have created a field on the Contact form for a date and time using DateTimeEdit control. In the properties for the new field, under DateTime, I have referring to the corresponding sql table and column that I created through the SLX database manager on the custom table C_contact. The column was created in a DateTime format.
What step have I left out? The dates do not stick when they are filled in. I save and refresh and when I go back to the record it is empty again. I know that I am forgetting something obvious but I can't remeber what. Please help this ameteur out! |
|
|
|
Re: DateTime Editor
Posted: 11 Apr 08 10:17 AM
|
It doesn't sound like you left anything out on the control properties, it may be your join between Contact and C_Contact that is causing the issue. Did you use a left, right, or inner join?
|
|
|
|
Re: DateTime Editor
Posted: 12 Apr 08 11:20 AM
|
| Agree. we don't know if the other table is 1:1 or 1:many....... may have to be 'thrown' to the other table via a SQL Update statement..... |
|
|
|
Re: DateTime Editor
Posted: 18 Apr 08 10:00 AM
|
There is a Join Parent table CONTACT Parent Field CONTACTID child table C_CONTACT child Field CONTACTID, Left 1:1. I have added other fields to the contact form that stored data in C_contact before within fields I've created in that table and never had problems. Is there a different Join I need to create? |
|
|
|
Re: DateTime Editor
Posted: 25 Apr 08 2:57 PM
|
Any Ideas? Remember, I am a novice and I may have neglected the seemingly obvious. |
|
|
|