PARADOX 5.0 Bugs/Not supported ?

PARADOX 5.0 Bugs/Not supported ?

Post by lik.. » Thu, 22 Feb 1996 04:00:00



Hi there

I have 2 different problems on PARADOX 5.0 for Windows (running presently
under Win 95)

The first concerns a PALRTL message when exiting PARADOX 5.0 after having used
an array of TCursors.

The second concerns a SQL query answering me with "Capability not supported"
although the help on the subject shows me I can do it.

Here they are
------------------------------------------------------------------------
                                1
-------------------------------------------------------------------------
There is what I am coding:

; type definition
        CursorArray = Array[] TCursor

; global variable
        InputArray      CursorArray

; in the PROC method

proc GetSortCursor(VAR SVVar_TC         TCursor         , ; HERE  !!!!
                VAR MaxRecords          longInt         ,
                VAR NumberOfFields      SmallInt        ,
                VAR tableVar            table           ,
                SortName                string          ,
                ....)
..
tableVar is initialised, an index is created after locking, the table is then
unlocked, the current index  is set to this new index and ...

        if (not SVVar_TC.open(tableVar)) then
                return false
        endif
..
endProc

; somewhere in the MAIN program
if GetSortCursor(InputArray[ModuleNumber]       , HERE
                        RecordsNumber   ,
                        FieldsNumber    ,
                        tableVar                        ,
                        SortName                        ,
                        ....)

The results of my program seem to be correct and nothing happens
that could raise an eyebrow. When I read the TCursors I dump the values
to some disk arrays that I interface with Borland C version 4.0
At the end I close each TCursor element and release these arrays as
well as the PAL array

BUT

When escaping Paradox 5.0 It comes up with this message under Windows 95:

PDOXWIN caused a general protection fault
in module PALRTL.DLL at 006c:00000aad.          <--(always the same here)
Registers:
EAX=56cf55b7 CS=43af EIP=00000aad EFLGS=00000206
EBX=00027e1c SS=2607 ESP=00008bd6 EBP=00008bde
ECX=00020038 DS=41e7 ESI=00020001 FS=0000
EDX=8153562f ES=562f EDI=00000ad8 GS=012f
Bytes at CS:EIP:
26 c4 5f 04 26 8a 47 04 b4 00 3d 1c 00 74 03 e9
Stack dump:
7e1c0ad8 41e7562f 08ce8bf5 01f043af 0ad856ff 01ec0ad8 00000094 8c0a41e7
45e708da 01f00001 0ad856ff 022c0ad8 41e756ff 06898c20 837c45e7 0ad84a3f

And I cannot restart Paradox as it tells me :
" Could not initialise IDAPI. Directory is busy "

on C:\PDOXWIN I have

PALRTL.DLL      654784          8-05-95

Could you please help me . I have spend days trying to find the problem
What is the cause of that message ?. Has there been a fix for that ?
Can I use Array of TCursor ? If not what is the alternative ?

I have tried DynArray but it gives me a message of "unallocated"
variable when I try to add the records of the VAr Cursor to the array.

------------------------------------------------------------------------
                                2
-------------------------------------------------------------------------
In PARADOX 5.0 for WINDOWS, I use a SQL string.
This SQL string does a select on the field "YEAR" of my table
Because Year is also a method/keyword my SQL will not work whichever
way I use it , which ever way the help on Local SQL tells me to do it.

With no quotes, indeed it tells me

   Invalid use of keyword
   line 1
   Token : YEAR

With quotes within a string or within an SQL -EndSQL statement, it says

   Capability not supported

Have I got a wrong version 5.0 of Windows ???
Should I install the CD which might be of a later version
Which dates should my files be of, which size ?

I cannot change Year to something else. There are too many data and programs.

-------------------------------------------------------------------------
Thanks for trying to help .

Michel - Johannesburg - South Africa

 
 
 

PARADOX 5.0 Bugs/Not supported ?

Post by Kuo-Sheng (Kas » Sun, 25 Feb 1996 04:00:00


: I have 2 different problems on PARADOX 5.0 for Windows (running presently
: under Win 95)

: The second concerns a SQL query answering me with "Capability not supported"
: although the help on the subject shows me I can do it.

: ------------------------------------------------------------------------
:                               2
: -------------------------------------------------------------------------
: In PARADOX 5.0 for WINDOWS, I use a SQL string.
: This SQL string does a select on the field "YEAR" of my table
: Because Year is also a method/keyword my SQL will not work whichever
: way I use it , which ever way the help on Local SQL tells me to do it.

: With no quotes, indeed it tells me

:    Invalid use of keyword
:    line 1
:    Token : YEAR

: With quotes within a string or within an SQL -EndSQL statement, it says

:    Capability not supported

: Have I got a wrong version 5.0 of Windows ???
: Should I install the CD which might be of a later version
: Which dates should my files be of, which size ?

Show us the SQL string... You may be able to use ` (back quote) or '
(single quote) instead of the " (double quote). Also, is this against a
local table or a genuine SQL table?

--
=========================================================================
Kasey K. S. Chang (a guy)             | Paradox for Windows Programmer

URL> http://userwww.sfsu.edu/~kschang | X-COM Guru   General PC expert
--------------------------------------+----------------------------------
Editor of XCOM and XCOM2 UN-official Strategy Guide -- FREE!  (See URL)

 
 
 

1. Problem with Paradox 5.0 but not wigh Paradox 4.5

I have a small problem.  I have a text file that I need to import into Paradox 5.0
for Windows, but the problem is that every time I try to import this text file, I get
an error that says something to the effect, "Corrupt Header..."  When I go and
execute the same procedure in Paradox 4.5 for Windows, I don't get any kind of error
and the text file is imported just fine.

If anyone has any ideas as to what the problem may be, please e-mail me at the

thanx

********************************************
Jose Luis Mora, Jr.

University of Illinois at Chicago (UIC)


Home Page:

    http://icarus.uic.edu/~jmora1

Saying of the Day:

     So Righ

*********************************************

2. Java application + Oracle SGBD

3. Paradox 5.0 Resolution Bug?

4. US - IA - IS Development Manager

5. Paradox 5.0 Insert and Delete Query Bug?

6. USA-MN SQL SERVER people needed

7. Paradox 5.0 BUG (?) Index out of date

8. will /3GB help?

9. Paradox 5.0 and WinWord6 ODBC password bug

10. Bug in the report in Paradox 5.0

11. Paradox [4.5,5.0][WIN] - Memory bug sol'n

12. Borland must use Paradox 5.0 Win for Customer Support

13. Bug in Paradox 5.0