sébastien baumann
|
| Posted: 07/19/2002, 1:33 AM |
|
I use codechargestudio , and topspeed files ( clarion )
I am connected to a data base :
- i can insert records by codechargestudio's form and they are created
in topspeed files.
but
- i can't display data base records in a codechargestudio's list .
Could you help me ?
Thanks,
Sébastien Baumann
|
|
|
 |
Geert van der Ploeg
|
| Posted: 07/19/2002, 2:35 AM |
|
I think you should mention a whole lot of additional info about the problem
before anyone could give a suggestion...
- What kind of query/code does codecharge generate?
- What's the result if you feed that query directly to your database?
etc.
Regards,
Geert van der Ploeg
Triple IT
"sébastien baumann" <sebastien.baumann@scoqi.com> wrote in message
news:ah8isr$297$1@news.codecharge.com...
> I use codechargestudio , and topspeed files ( clarion )
> I am connected to a data base :
> - i can insert records by codechargestudio's form and they are
created
> in topspeed files.
> but
> - i can't display data base records in a codechargestudio's list .
>
> Could you help me ?
>
> Thanks,
> Sébastien Baumann
>
>
>
>
|
|
|
|
sébastien baumann
|
| Posted: 07/19/2002, 2:55 AM |
|
I use php code ;
there are no results if i feed query directly to my database ( search
.....)
When i make an order request ... we think it makes an order in data base ;
but it doesn't display records...
|
|
|
|
Shawn Mason
|
| Posted: 07/20/2002, 10:07 AM |
|
Couple of things to remember when using the tps ODBC driver is to make the
cursors client-side. Also, if you own CC then I might suggest trying it for
a grid since it is almost monkey-proof in creating grids. I suggest this
just to make sure it's not an ODBC setup problem.
Also, you could run a trace on the ODBC calls to see exactly what is being
generated. But, in the end, you will find the tps files to not be a very
stable environment using the ODBC driver. This has nothing to do with the
tps format which is a great ISAM backend, but the ODBC driver for it is
rather weak. It can be done, but expect it to buckle when you turn up the
heat.
--
Kindest Regards,
Shawn Mason,CCD,MCP
I.S. Software Design Associates
"sébastien baumann" <sebastien.baumann@scoqi.com> wrote in message
news:ah8nmd$al7$1@news.codecharge.com...
> I use php code ;
> there are no results if i feed query directly to my database ( search
> ....)
> When i make an order request ... we think it makes an order in data base
;
> but it doesn't display records...
>
>
>
>
>
>
|
|
|
|
=?iso-8859-1?Q?s=E9bastien_baumann?=
|
| Posted: 07/22/2002, 4:15 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_00EF_01C23181.DC5D9D20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There are not problem with connection to database because it is ok with =
MS query !
i am able to define SQL parameters in data source property of my data =
base ...!=20
when i am in review data i see all records data base and all fields....!
i see all parameters name of table values when i click to live page =
.....!
i see all title of fields but i just see no records for all my =
records...
if i click on the header to make an order ; it seems to work in database =
!
S=E9bastien
------=_NextPart_000_00EF_01C23181.DC5D9D20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2716.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DVerdana size=3D2> There are not problem with =
connection to=20
database because it is ok with MS query !</FONT></DIV><BR><FONT =
face=3DArial><FONT=20
size=3D2><FONT face=3DVerdana>i am able to define SQL parameters in data =
source=20
property of my data base ...! <BR>when i am in review =
data i see=20
all records data base and all fields....!<BR><BR> i see all =
parameters name=20
of table values when i click to live page ....!<BR>i see all title of =
fields but=20
i just see no records for all my records...<BR><BR>if i click on the =
header to=20
make an order ; it seems to work in database=20
!</FONT><BR><BR><BR>S=E9bastien</FONT></FONT></BODY></HTML>
------=_NextPart_000_00EF_01C23181.DC5D9D20--
|
|
|
|
|
