Blank spaces

vivekg95 · #1 (**permalink**) 12-22-03, 06:23

How can I pass blank spaces for Required fields into database from Forms as

Initial Value , On insert , Post insert options does not work.

Thanks

edwinjames · #2 (**permalink**) 12-22-03, 09:03

- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?

-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?

vivekg95 · #3 (**permalink**) 12-22-03, 09:10

Quote:

Originally posted by edwinjames
- HAVE YOU TRIED SETTING THE SETTING THE DEFAULT VALUES ON THE FIELDS?

-DO THEY HAVE TO BE SPACES? WOULD 'NULL' VALUES WORK?

1. Forms will not take blank spaces as it will truncate it for varchar2 fiedls .

2. All fields are required.

3. Assigning it from triggers have different problems of record locking.

Internet Services

Web Development

Digital Marketing

Consumer Tech