Re: Database Results Error
From: dito (c_dito_at_yahoo.com)
Date: 03/23/04
- Next message: Jim Buyens: "Re: FP 2003 what features to use"
- Previous message: Crash Gordon®: "Re: How to save a web page"
- In reply to: Mettá: "Re: Database Results Error"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 09:02:21 -0800
I too, am having problems with FP database access. We
have multiple servers, each with multiple webs, using
access,mssql,and sybase databases. It seems that the
queries are now case sensitive with respect to the where
clause, and the variable in the where clause has to be
explicitly declared in the select statement...i.e.
select * from table1 where id = '::id::' used to work...
Now the query must be written as follows: select id, *
from table1 where id = '::id::' and it cannot contain "Id
= '::id::'", the case makes a difference. What made this
change???
>-----Original Message-----
>I am having serious problems since SP3 inc loss of db
updates and the
>complete loss of DISTINCT within custom sql statements
within DRW's
>
>Please let me know/post here if you find a solution.
>
>M
>
>"susan" <anonymous@discussions.microsoft.com> wrote in
message
>news:ead801c4104a$cfbfe2e0$a601280a@phx.gbl...
>> We have a website with ASP page connected to a MDB
>> database. Previously, this worked fine. Users were
able to
>> read and modify information. Suddenly, they can't
modify
>> information anymore. When they try to submit changes
they
>> get "Database Results Error." The only thing that we
know
>> has change for certain is that we applied Office SP3 to
>> the server. Could that be causing the problem? If not,
>> whatelse could it be?
>
>
>.
>
- Next message: Jim Buyens: "Re: FP 2003 what features to use"
- Previous message: Crash Gordon®: "Re: How to save a web page"
- In reply to: Mettá: "Re: Database Results Error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
