I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

July Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding Board   Print This     

Paradox Tables Topic

Paradox table structure, TUtility/Table Repair, and related including accessing Paradox tables from Delphi, .Net, Java, VB, etc.
 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

Pete.D2
Opening multiple tables at once
I need to open a data table and run through it checking a particular field for matches in a separate look up table. I need to flip repeatedly between two open tCursors. I declared my two tCursors and opened them expecting them to open independently, like so: tc.open("one") get the string tc2.open("two"), expecting two to be opened in another work area. search a match for the string in Two's FIND field if found manipulate the string tc2.close() update one's data with the string, expecting one to just be there and selected. move to the next record and repeat What am I missing in the way these tables/tcursors need to be opened or selected? The way it is now tc2 doesn't seem to be being selected when it's opened. NONE of code examples I checked online used two tCursors in the same code block.
82 days ago
18 replies. Last post:

Pete.D2
It's a shame these useful products like Paradox and FoxPro never got upgraded to 64 bit. They would still have their place I think.
42 days ago
Nothing New Since Your Last Visit
280
Hits

Thread 24 of 25
Thread Starter  

Bob S.
Database Desktop on Windows 10
I've been using Database Desktop for years to maintain Paradox tables, but it now appears that DBD doesn't work on Windows 10 for build 1703 or later.  Is there an updated DBD that does work?  Or is there an alternative tool I can use?  I've found several tools that will let me view and modify the data in Paradox tables, but none that will let me modify the table structures.  Any suggestions?
5 months ago
4 replies. Last post:

Bob.S6
Good suggestion.  I'll jump over to the Delphi Group and make the same posting.
5 months ago
Nothing New Since Your Last Visit
289
Hits

Thread 23 of 25
Thread Starter  

Jay.M
STRINGLIST DOCUMENTATION
Paradox 11.0.0.411 stringList.setString ( const stringID longInt, const stringValue string ) logical   Is there a documentation error here.  And for that matter does anyone have information to documentation updates/changes?   I seem to be able only to use a smallInt.    
5 months ago
1 Reply:

Steven.G
you can check the bug list.. I never used the stringlist http://hem.bredband.net/bertilisberg/
5 months ago
Nothing New Since Your Last Visit
133
Hits

Thread 22 of 25
Thread Starter  

Bob Green
JDBC and the BDE
Our web application queries the Paradox tables through JDBC every 30 minutes to update our local copy of the data. This scheduled query will run, for about a day and a half before it starts failing with this error:, , Error message: Error while trying to connect to database, Exception message:, While trying to obtain Connection object, there was a ProviderFailure exception on the server., Following are BDE Error messages:, BDE ERROR CODE: 9488 MESSAGE: Too many sessions., , We are closing all connections and database resources after the update is finished. For, some reason, the server is running out of resources., , Is increasing the number of sessions in APPSRV~1.pro from the default 45 to a higher number the right direction to address this issue?, , Bob G.
16 years ago
Nothing New Since Your Last Visit
2922
Hits

Thread 21 of 25
Thread Starter  

riskmansea
INVALID PARAMETER ERROR
Attempting to add data fields to a table and I get invalid parameter error. Error refers to links between tables. I do utilize lookup tables on the form when adding data to this table which is functioning without any issues
9 months ago
1 Reply:

Steven.G
one of the values in the table being added, isn't in a lookup table and/or doesn't meet a valcheck rule?
9 months ago
Nothing New Since Your Last Visit
192
Hits

Thread 20 of 25
Thread Starter  

PS_426
Seat number of accounting entry 1000001 is incorre
We have an accounting table that has reached the one million seat. When we export this table to another program called contaplus we obtain an error "Seat number of accounting entry 1000001 is incorrect". we do not know how to start again with the accounting entry 1 or if there is a counter to zero this table ..., But the problem is that right now we do not have Paradox programmer. I can't upload images, a mistake comes up. Thanks in advanced!
9 months ago
2 replies. Last post:

Gemma.L
Ok, I undertand! thank you very much for your advice
9 months ago
Nothing New Since Your Last Visit
230
Hits

Thread 19 of 25
Thread Starter  

Klepsis
error code meaning
I am suddenly getting an error when I try to post a record to a table.  The code is 30463. How do I find out what this means and what causes it?
13 months ago
8 replies. Last post:

Eugene.W
Thanks.  I'll do some research in my object pal manual and see where that takes me.  :)
13 months ago
Nothing New Since Your Last Visit
483
Hits

Thread 18 of 25
Thread Starter  

Eugene.D2
too long file name, tables won't open
my problem of being unable to open tables because the file name is too long for a version 5 table - I've read in one of my texts that the later versions support long file names.  All I want to do is open the tables.  Since I've had no reply to a way to change the cumulative pathways, could there be another option?  Is there a way to change the tables from the earlier version that doesn't support long file names to my later version 11 Paradox.  Lacking a way to do this the  easy way (I couldn't find anything in the literature to do this, i.e. changing the table version), would it be possible to find out exactly the original paradox version of the table, copy the table to that version so it would open.  Then would there be a way to import the table data to a table constructed under the new version (the design duplicated from the table opened in the earlier non-long file name version).
52 months ago
6 replies. Last post:

Martijn.G
Sorry, it took me a while to get back to you. In the mean time, I bought a new W10 computer and re-installed P11. The problem with the tablenames has been fixed now. Unfortunately, an other problem occured. But I will look for the right thread to see if I can find an answer. Thank you for your help!
13 months ago
Nothing New Since Your Last Visit
1601
Hits

Thread 17 of 25
Thread Starter  

Jay.M
attempt unnamed file past end
{Too Long!}
13 months ago
9 replies. Last post:

Jay.M
Thanks Steve... your suggestion worked... message gone all is well!
13 months ago
Nothing New Since Your Last Visit
468
Hits

Thread 16 of 25
Thread Starter  

Laxman.D
Table Structure export
Hi all, I would like to know if there is any way I can export the structure of all the tables from paradox using script and save as .txt. Appreciate an early response.
26 months ago
1 Reply:

Sam.S
I don't have a canned process for you, but you can do a fs.enumfilelist to get an array filled with table names, then enumfieldnames and enumindexstruct to get the details of the table.  then open those with a tcursor scan through the details and use a ts.writeline to write to the text file. I have done similar to document and manipulate the tables in a given directory.
26 months ago
Nothing New Since Your Last Visit
804
Hits

Thread 15 of 25
Thread Starter  

Cottage Builder
Paradox Reports
Is it possible to design a Paradox Report in such a way that if a record meets a particular criteria, the colour of the record can be changed. Ross
28 months ago
1 Reply:

Anonymous
Just off the top of my head I think I'd design and print a form that did that rather than a report. --- Steve Caple
28 months ago
Nothing New Since Your Last Visit
748
Hits

Thread 14 of 25
Thread Starter  

CliffSuttle
Table Repair in Version 10
Using version 10, when I try and run the table repair utility, I get a message that state "Invalid Alias" and the table repair won't run. What gives? Anyone else run into this? Is there a work around?, , Any help would be appreciated.
17 years ago
Nothing New Since Your Last Visit
3407
Hits

Thread 13 of 25
Thread Starter  

Larry.D
Private Alias Change
I have been using Paradox 9 for some time. Recently I messed my self up someway ......and my PRIV Alias Path got changed. I want to be able to change its Path. It Seems Paradox 9 will not allow me to change The PRIV Alias. Any Help would be welcome.  Larry Dunn Kenmore, NY
49 months ago
2 replies. Last post:

Dan
Have you tried the preferences dialog on the tools tab.  The Database tab has an option to change the location of the priv dir.
49 months ago
Nothing New Since Your Last Visit
3604
Hits

Thread 12 of 25
Thread Starter  

Cottage Builder
Paradox Development
Hi Everyone, I am running Paradox 11 under windows 7/64.  When I put Windows 7/64 in I had no end of problems with software that would not run on it.  Fortunately, Paradox did.  My question is, "is anyone continuing to develop Paradox Win, other than Corel or is it's future compatibility dependent  on them.  As I understand it, there has been very little development work on Paradox since version 9.  What has been done is virtually tweaks.  Am I right?  Does anyone have any thoughts on the subject?
49 months ago
1 Reply:

mprestwood
{Too Long!}
49 months ago
Nothing New Since Your Last Visit
1720
Hits

Thread 11 of 25
Thread Starter  

Ben.N
.NET Control File location setting
When I want to open the files on my server I get the message; "You have attempted to open a database that is in use by someone else, but data can't be shared. You must set the location for the .NET Control file." Of course the file is not in use by anyone else.  I appreciate knowing your suggestions/replies for how to set the .NET Control File location. Thanks
52 months ago
2 replies. Last post:

Dan
More than likely you have copied the .lck files along with the tables.  Delete the .lck files in the directory containing the table and you should be good to go.
51 months ago
Nothing New Since Your Last Visit
1633
Hits

Thread 10 of 25
Thread Starter  

Eugene.D2
table lookup restricting data entry
my thanks to dan fought in resolving my former problem with too long file names.  it worked great.  new issue found in resurrecting old files.  is there a way to use table lookups to speed data entry, but still allow a data entry person to enter a value not in the lookup table when they are using a data entry form (with a drop down box on it accessing the table lookup).
52 months ago
1 Reply:

Dan
If you use the paradox object expert you can get some fairly good code to fill a combo box with values from a table.  The combo box does not have to be restricted to the values in the "Lookup Table'.  However, be cautious using this.  A large table can cause errors, since the size of the list is limited.  For ease of use I go to a pupup list in a custom form when the tables get too large.
52 months ago
Nothing New Since Your Last Visit
1439
Hits

Thread 9 of 25
Thread Starter  

Eugene.D2
After a stroke in 1998, I'm tr...
After a stroke in 1998, I'm trying to use previously developed tables forms and reports, with a number of problems.  My use of Paradox started with the first version and progressed through the new versions until 1998.  My first problem is that using version 9 in trying to use tables original copied from earlier versions onto later versions, I'm getting a message "unable to open file name too long for a Paradox version 5 table".  My assessment is that in copying files between old and new computers new additions were made to the pathway to the directories and sub-directories and that was called the file name.  Is there a way to get rid of the old pathways?  i.e. is there change the file name some way to get rid of the problem?
52 months ago
Nothing New Since Your Last Visit
994
Hits

Thread 8 of 25
Thread Starter  

Tom.K3
Tcursors rounding number fields to 2 decimals
I have a number field in a table that stores gallons value up to 3 decimal places. I have placed a format on the field so it displays properly. When I open the table directly and look at the column and it shows the value rounded to 2 decimals however if I click in the field it will then show all 3 decimals so I know the actual value is being stored. The problem I am having is when I use a tcursor to open the table and try to get the value of that field it will only give me the rounded value and not the full 3 decimal place value. I need the full 3 decimal value so I can accurately use it for other calculations.  Help would be greatly appreciated.
59 months ago
4 replies. Last post:

Tom.K3
Thank You, that seemed to work. Tom
59 months ago
Nothing New Since Your Last Visit
2059
Hits

Thread 7 of 25
Thread Starter  

techturtle
Extracting BLOB data
{Too Long!}
6 years ago
4 replies. Last post:

Jo_Lynne.L
http://pnews.thedbcommunity.com/cgi-bin/dnewsweb.exe?cmd=article&group=pnews.paradox-discussions&item=30665&utag= Hope that works. I haven't got around to it, but I need to get them out of PDX.
6 years ago
Nothing New Since Your Last Visit
3449
Hits

Thread 6 of 25
Thread Starter  

Larry.D
Paradox 9 on Windows 7
I just installed (via CD) Paradox 9 on Win7. It loaded and it works fine with my files except for this problem: For some unknown reason I'm not able to use Paradox.pic file on any table. A message appears "/Paradox.pic was Not found" However, I did find this file in the Paradox directory. I re-installed the Paradox program a few times with no luck correcting this problem This feature on Paradox  9 works on Win98 and XP. Any Help would be great. Larry,
7 years ago
3 replies. Last post:

Anonymous
I have the same problem with WinXP x64 -- but not with 32-Bit version --- Garth Hutchinson
6 years ago
Nothing New Since Your Last Visit
3402
Hits

Thread 5 of 25
Thread Starter  

jlockley
clicking on blob field erases content.
Database with 14K entries is back up to a corrupted database with loss of data. Repair shows no corruption. Working currently on Vista (Vista issues clear). Trying to open the blob files contents to rebuild the original deletes individual blob field contents permanently (leaving record and revisiting or closing file and reopening shows the records accessed without their stored objects). I keep hoping someone has an idea about this. it is most likely connected to the original issue of file corruption with disappearance of multiple blob entries. (about four hundred at last count). Exporting the file to a different folder and attempting to access the contents in the exported file = same results.,
6 years ago
Nothing New Since Your Last Visit
1606
Hits

Thread 4 of 25
Thread Starter  

jlockley
Loss of Blob Field entries.
{Too Long!}
6 years ago
Nothing New Since Your Last Visit
1867
Hits

Thread 3 of 25
Thread Starter  

rahill844834
Table restructure & desktop settings
I am using PDX 11 with Hot Fix 1.  If I try to restructure a table, I receive a "Unexpected general protection violation" error when trying edit the "table lookup" function. Also I am unable to save Desktop Settings once machine is shut down.  They are saved if app is closed and reopened. Can anyone help. Regards, Dick Hill
7 years ago
Nothing New Since Your Last Visit
2019
Hits

Thread 2 of 25
Thread Starter  

gbash
Paradox 7 Table LookUp Error on Save
{Too Long!}
8 years ago
1 Reply:

Anonymous
I have same problem --- rasto
7 years ago
Nothing New Since Your Last Visit
2168
Hits

Thread 1 of 25
Thread Starter  

Tony.Curiale
Help with Home Network
{Too Long!}
8 years ago
18 replies. Last post:

Anonymous
Thank You Mike.  It took me a while to find it before, and a quick source is always handy.  To be honest when I needed the file I did not even think about lookiing through your resources.  Duh!  I feel a bit slow of mind when I think about it. Thanks Ralph --- Ralph Maxwell
7 years ago
Nothing New Since Your Last Visit
5547
Hits

New Thread
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

1,656 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2018 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech