zmoerf
Posts: 12
|
| Posted: 09/13/2007, 9:23 AM |
|
i have to build manual record & wizard record builder all field is work normaly only data type date can't input in database . i don't know whats wrong with my ccs because i have build record with wizard.
i have create database with mysql navicat, and i use CCS 3.1
sory my english its not good.. 
all my project have problem with input date
|
 |
 |
datadoit.com
|
| Posted: 09/13/2007, 10:27 AM |
|
zmoerf wrote:
> i have to build manual record & wizard record builder all field is work normaly
> only data type date can't input in database . i don't know whats wrong with my
> ccs because i have build record with wizard.
>
> i have create database with mysql navicat, and i use CCS 3.1
>
> sory my english its not good..
>
> all my project have problem with input date
> ---------------------------------------
Make sure you set the date field's DBFormat on your record form.
|
|
|
|
zmoerf
Posts: 12
|
| Posted: 09/13/2007, 10:37 AM |
|
yes i have set
my record textbox properti
Data type : Date
Format : mm/dd/yyyy
DBFormat : mm/dd/yyyy
but this record can't input
|
|
|
|
wkempees
|
| Posted: 09/13/2007, 10:42 AM |
|
1:Start off by checking you MySQL date format settings.
2:In Project Settings make sure you use the same format in your connection
setup.
also check out your default date setting: ShortDate, GeneralDate and so on.
3:In the textboxes (after generation) no format should be needed for the
choosen defaults, like ShortDate and so on, only needed if you want to use a
different than standard format.
Then regenerate project.
Walter
(Following these steps everything should turn out to be simple)
"zmoerf" <zmoerf@forum.codecharge> schreef in bericht
news:546e9755d525f0@news.codecharge.com...
> yes i have set
> my record textbox properti
>
> Data type : Date
> Format : mm/dd/yyyy
> DBFormat : mm/dd/yyyy
>
> but this record can't input
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
datadoit.com
|
| Posted: 09/13/2007, 12:13 PM |
|
zmoerf wrote:
> yes i have set
> my record textbox properti
>
> Data type : Date
> Format : mm/dd/yyyy
> DBFormat : mm/dd/yyyy
>
> but this record can't input
> ---------------------------------------
Set DBFormat to yyyy-mm-dd
This is the format of a MySQL DATE field.
|
|
|
|
zmoerf
Posts: 12
|
| Posted: 09/14/2007, 4:11 AM |
|
i have set my date format in ccs project and in my database
ccs = my project setting -> locals&encodings -> date display format [yyyy-mm-dd]
mysql = format date is -> yyyy-mm-dd
i don't know what's wrong with my ccs
|
|
|
|
wkempees
|
| Posted: 09/15/2007, 5:51 AM |
|
You state to have set mysql = format date is -> yyy-mm-dd.
But have you checked the actual date format of your MySQL setup?
Mine for instance is YYYY-mm-dd-hh-mm-ss
Make sure that in the connection these two match!
Walter
"zmoerf" <zmoerf@forum.codecharge> schreef in bericht
news:546ea6c4ea84c9@news.codecharge.com...
>i have set my date format in ccs project and in my database
> ccs = my project setting -> locals&encodings -> date display format
> [yyyy-mm-dd]
> mysql = format date is -> yyyy-mm-dd
>
> i don't know what's wrong with my ccs
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
