rstewart
Posts: 17
|
| Posted: 08/01/2007, 11:44 AM |
|
1. Generate record with wizard, connection to SQL express 2005
2. run 'Live Page' everything is OK
3. In Design mode, switch a field position from bottom of table and place above other other fields.
4. Run 'Live Page' - some fields do not display values
5. switch field back in Design Mode and everything works OK.
HELP !!!!!!!!!!!!!!!!!!!! 3.2.0.1
Testing form on locally on XP IIS using ASP and templates. Connected to a local sql express database.
If I move a field to a new location on the form page then random fields are not populated on a record. Only works if a generate a record form with fields in the databases order.
I'm I doing something wrong.
I tried it with just two field
e.g. Title, Name horizontally arranged
if I move the Name above the title field
Name field returns blank (no value).
If I move to back to the original position.
It shows both field values.
_________________
looking for work in a sunny country. |
 |
 |
rstewart
Posts: 17
|
| Posted: 08/01/2007, 12:54 PM |
|
It was the XP ODBC connection in XP.
When I changes codecharges connect to SQL Native String Connection everything worked.
What's are the step by step setting in ODBC for codecharge to working without returning nulls and mixing up field values????
Revised this old message 08/01/2007 on May 7, 2008
I believe they fixed the ODBC bug but informed me not to use SQL native string connection. The opposite of the above.
_________________
looking for work in a sunny country. |
|
|
|
advcomputer
Posts: 68
|
| Posted: 05/06/2008, 5:59 PM |
|
I have the same issue.
When I use the bulder and have the fields in the same order as the db structure all is fine. Move a field up or down on the form and it does not work.
I have to rebuild the form again.
There seems to be some correlation of this issue with the use of texarea field.
Yes Software - Any Ideas?????
-Jeff Goldstein
|
|
|
|
Stanj
Posts: 166
|
| Posted: 05/06/2008, 7:44 PM |
|
Have you contacted support? They do not monitor or respond on the forum. Peter sometimes posts but he is not representing the company, only himself as a knowledgeable user.
I used to use asp but never ran into the problem you are seeing.
_________________
Stan
St Petersburg Russia |
|
|
|
rstewart
Posts: 17
|
| Posted: 05/06/2008, 8:03 PM |
|
I far as I know this was resolved by using the latest / last version (update) of version 3.
However, seen then I always use Page event: On Initialize View then add:
TemplateFileName = "Template-whatever.htm"
---------------
1. I always generate the page and let codecharge rendered the HTML file.
2. I then open that page in an editor like Frontpage.
3. Save it as Template-whatever.html
I never edit or use the html page codecharge produces!
If I have to add more control later on. I simple regenerate the page then copy and paste the the new html code codecharge produces into the template-whatever.html page using my own editor (frontpage)
------------------
Believe me this is the way to go !
Also, you will never get error messages about missing template blocks since you never edit the original html page that codecharge produces.
Hell, sometimes I just select all fields and render the page, that way I can just drop and field I what on the templat-whatever.htm file.
For label you can just use the standard {labelname} brackets. Radio buttons require copying the start and closed block tags as do some of the other controls.
NOTE : I do not have version 4 and will not until they fix or allow common files to reside in a seperate folder and the ability to remove unneeded ones (been asking for this for 3 years!).
Sometimes the simplest fixes take the longest.
_________________
looking for work in a sunny country. |
|
|
|
rstewart
|
| Posted: 05/06/2008, 8:03 PM |
|
I far as I know this was resolved by using the latest / last version (update) of
version 3.
However, seen then I always use Page event: On Initialize View then add:
TemplateFileName = "Template-whatever.htm"
---------------
1. I always generate the page and let codecharge rendered the HTML file.
2. I then open that page in an editor like Frontpage.
3. Save it as Template-whatever.html
I never edit or use the html page codecharge produces!
If I have to add more control later on. I simple regenerate the page then copy
and paste the the new html code codecharge produces into the
template-whatever.html page using my own editor (frontpage)
------------------
Believe me this is the way to go !
Also, you will never get error messages about missing template blocks since you
never edit the original html page that codecharge produces.
Hell, sometimes I just select all fields and render the page, that way I can
just drop and field I what on the templat-whatever.htm file.
For label you can just use the standard {labelname} brackets. Radio buttons
require copying the start and closed block tags as do some of the other
controls.
NOTE : I do not have version 4 and will not until they fix or allow common
files to reside in a seperate folder and the ability to remove unneeded ones
(been asking for this for 3 years!).
Sometimes the simplest fixes take the longest.
_________________
looking for work in a sunny country.
---------------------------------------
Sent from YesSoftware forum
http://forums.yessoftware.com/
|
|
|
|
rstewart
Posts: 17
|
| Posted: 05/06/2008, 8:13 PM |
|
wow a double post !! And i just it submit once !!!
_________________
looking for work in a sunny country. |
|
|
|
advcomputer
Posts: 68
|
| Posted: 05/07/2008, 7:45 AM |
|
I am using the latest build of CCS
Version 3.2.0.4
I will see if the same happens under 4.o
|
|
|
|
rstewart
Posts: 17
|
| Posted: 05/07/2008, 8:26 AM |
|
I'm using the same version
Try this:
Start menu: RUN
enter: %SystemRoot%\system32\odbcad32.exe
setup a ODBC connection to your SQL Server
In CodeCharge Project Explorer:
click Connections:
Design tab:
Database: "SQL Server"
check "Use ODBC Data Source Name"
fill in the rest of the fields
My configuration works OK using the above settings.
_________________
looking for work in a sunny country. |
|
|
|
