LN
|
| Posted: 08/26/2002, 5:43 AM |
|
Hi,
I just downloaded the Studio-trial version, and by the first run discovered 2 errors.
1. The program can't handle DB-column names with a "reserved word nature" like "BYTE" and "BY"
2. The program can't handle boolean values with a Danish Access-DB.
Is this kind of errors the "standard" for CCS, -or have I just been unlucky?
Regards..
|
|
|
 |
WilliamB
|
| Posted: 08/26/2002, 10:17 AM |
|
1. Yeah, because SQL like any other language has reserved words. The SQL standard dictates what is a reserved word or not, not CodeCharge.
2. Again, SQL does not support database specific data types. Boolean simply means one of two possible values, and there is no telling what those two values can be. So you have to use a data type supported by SQL, for instance an interger or number 0;1.
|
|
|
|
LN
|
| Posted: 08/27/2002, 3:14 AM |
|
WilliamB,
1. The Studio-trial version handles SQL-reserved words okay, by wrapping these
word with []. But it seems like Yes-Software has missed the "reserved words problem" when defining variables (f.ex. "Dim Byte"). It must be fairly easy for Yes-software to avoid this problem, by implementing a naming standard of some sort when defining variables.
2. I would expect that Yes-software had "covered" data-types in "the most used databases"-category (like oracle, mysql, sqlserver, access).
Therefore I would not have expected it to bee a problem to recognize that Access-DB booleans are saved with true/false or that sqlserver uses 1/0.
Since these things "popped up" at the first run, -it did shake my believe in the product a bit! I'm aware that I can change the database-definition, fix the code and get it to work. But I would like to know, before I buy this product, if the product is great (or fancy).
Regards..
|
|
|
|
Superkikim
|
| Posted: 08/27/2002, 5:04 AM |
|
LN,
I'm using codecharge since version 1.x. This is a fantastic software. The move from CC2.x to CCStudio was a bit difficult because it is a completely different approach. ANyway, this is very a great software.
It helps a lot if you already know the language you want to use, and HTML.
By having these skills, you can do almost everything you want. And as it is a new software, we all have a chance to give an input for next releases (http://support.codecharge.com, see news & updates)
But the software is not the only thing. Yes Software is providing an excellent support answering any request within 24h, with valuable solutions. They are pleasant and never answer just "read the help file" or "read the doc", also if you ask a "silly" question 
Additionnaly, the communities about Codecharge (they are some now, as I understood) are an excellent way to get help about the use of the product and the coding...
I never found yet a so good software at a so good price and so flexible !
|
|
|
|
Nicole
|
| Posted: 08/28/2002, 2:32 AM |
|
Hello,
first of all I want to say that CCS cannot handle everything for you, you should keep some things in mind while creating the project and change some settings accordingly. So,
1. assign aliases to fields that you know are the reserved words in db or programming language you're using.
2. to work with boolean field you should:
- select or type in proper db boolean type format in the server side connection settings;
- for boolean field on the form set Data Type to Boolean. For checkboxes set Checked Value to db value corresponding to "true" and the similar for unchecked.
|
|
|
|
|
