DRW, SQL and Numeric Data Types (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

JMo -> DRW, SQL and Numeric Data Types (2/16/2004 15:01:54)

I have SQL tables that I am trying to edit by using the DRW. They worked in FP2000 and now that I have 2003 any table that has a field with a numeric data type blows up the edit portion of the DRW saying that the precision is invalid. I've tried changing the precision in the SQL table and nothing seems to work. Numeric is the only data type I have had this problem with so far..... If I change the data type to Int, it works. Anyone have any ideas? I really need numeric values for my calculations...

Thanks!



Spooky -> RE: DRW, SQL and Numeric Data Types (2/16/2004 16:31:53)

Where are the calculations being performed?
Whats the exact error message?



JMo -> RE: DRW, SQL and Numeric Data Types (2/16/2004 16:52:57)

The calculations are done in views after the data is in the SQL tables. For example, they enter 50 numbers and then I use a view to sum them.

The DRW works until you hit enter on the edit screen. The error I get on new DRW's I'm creating is this:

Database Results Wizard Error
Description: The precision is invalid.
Number: -2147467259
Source: Microsoft OLE DB Provider for SQL Server.


The error I get on my old DRW's that were initially created in 2002 is:

Database Results Wizard Error
Your page contains a query with user input parameters that could not be resolved.
This could happen if your DatabaseRegionStart webbot has an empty or missing s-columnnames or s-columntypes attributes.
You may need to read Microsoft Knowledge Base Article 817029.

If you have any information that could help, I would greatly appreciate it. I have checked all over the web and have done all the updates to try and fix it and I am stuck!

THANKS!!!



Spooky -> RE: DRW, SQL and Numeric Data Types (2/16/2004 18:56:55)

For the error, I would suggest trying the old include files first - does it cure the problem?



cfreema7 -> RE: DRW, SQL and Numeric Data Types (2/25/2004 15:23:51)

Spooky,

This close but its extremely unstable. I have seven tables in a database, in a page returning various bits of project status. First hit nothing worked. Then I refreshed, and two tables returned, then all seven, then six. I then replaced the hard coded parameter with the variable, and now only four of the tables return data, the other three give the error message.

As I said before, this all worked under fp2002. The tables are small and are components driven by two variables, Proj_ID and Date. When I hard code the criteria, everything works. When I use a variable, ?proj=1015, and hard code the date, all seven worked. Then I used the date variable, ?proj=1015&d=02/13/04 and code the each table:
fp_sQry="SELECT * FROM status WHERE (proj_id = '::proj::' AND date = '::d::')"

This returns six of seven tables [:@] . I get the feeling that if I refresh it enough times, this will shake things up, but its too unstable.

Here's the page: http://www.sflocals.com/evaguru/kaiser/kaiser.asp?proj=1015&d=02/13/04

Any other thoughts?



cfreema7 -> RE: DRW, SQL and Numeric Data Types (2/25/2004 18:13:01)

Spooky,
I may have found a workaround for the _fpclass problem. The issue may not be with the fp2003 app, but with an additional file the app writes to the server.

I couldn't get things working right, so I decided to back out for a moment, and create a new database, outside of my usually web folder. I used the DRW to create a whole new database. I created the fields via DRW step 2, and followed the full process as usual. At the end, the database worked fine and allowed for hyperlinked parameters. Then, I took a look at the _fpclass folder and noticed that in addition to the _vti_cnf folder, there was a 2000 folder. this folder had a new FPDBLIB.INC, all caps, file in it. Don't know what the difference was, but I copied the entire contents of the new _fpclass folder into the web site where I was having problems, replacing the old folder, and voila, everything is working again.

Spooky, you had the zip file with the old include files, but it does not have the new 2000 file. This may need to be created for each website on an individual basis. My website has over 30 databases with close to 80 tables and hundreds of pages, and after I ftp'd the new _fpclass folder over, every database was back to working properly.

Thanks for the shove in the right direction, because I was ready to some damage to my software setup, and that's wasn't the problem.

Chris



JMo -> RE: DRW, SQL and Numeric Data Types (2/27/2004 9:20:47)

You guys are great for all of the help! My initial fix was to change the numeric data types to 3 in the html code and it has worked great. At least now my most important db is running! As soon as I get up the guts, I will try the fp_class fixes. Thanks for all your help! I still can't believe Microsoft doesn't address the issue! I knew I wasn't crazy! Thanks again! JMo



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.125