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

March 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  

rum
Table Corruption
{Too Long!}
59 days ago
4 replies. Last post:

Steven.G
{Too Long!}
59 days ago
Nothing New Since Your Last Visit
104
Hits

Thread 24 of 25
Thread Starter  

philiptdotcom
how to re-attach .Mxx files (memo fields) to a .DB
I have experienced the disappearance of ALL memo field values (multiple memo fields, thousands of records) in at least one table (although the *.Mxx files still exist). Based on info from another, old thread, I understand that there‘s neither a "built-in recovery tool" nor a "simple recovery process" to re-attach .Mxx files to a .DB, but where might I find the explanation of a tool or process--regardless of complexity--to explain how to do it myself? Thanks in advance for any help! Aloha, Philip T. (PT@PhilipT.com)
6 months ago
1 Reply:

Steven.G
duplicate post.. you have to write a routine to scan the table and reinsert the files/data
6 months ago
Nothing New Since Your Last Visit
280
Hits

Thread 23 of 25
Thread Starter  

Stevron
Memo Field Accepting "Hard Return"
I have been away from Paradox for a few months, but am in the process of updating some of my old work., , I was wondering how I would set a memo-field to accept "Returns", or to simulate a line break from the keyboard., Users enter brief trip reports and have been complaining they cannot separate their paragraphs properly. I haven't been able to find any properties which look promising, but I'm sure this problem has been solved in some way or another on this board. , , Thanks in advance, Eric
14 years ago
2 replies. Last post:

philiptdotcom
Thanks! -pt
6 months ago
Nothing New Since Your Last Visit
1659
Hits

Thread 22 of 25
Thread Starter  

ShortY406
Paradox 5 access with Java
Hi together,, iam searching for an example, how i can get an access to a Paradox 5 with Java., I hope someone can help me. Thanks for all comments.
12 years ago
Nothing New Since Your Last Visit
2796
Hits

Thread 21 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.
11 months 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.
9 months ago
Nothing New Since Your Last Visit
962
Hits

Thread 20 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?
13 months ago
4 replies. Last post:

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

Thread 19 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.    
13 months ago
1 Reply:

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

Thread 18 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.
17 years ago
Nothing New Since Your Last Visit
3184
Hits

Thread 17 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
17 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?
17 months ago
Nothing New Since Your Last Visit
459
Hits

Thread 16 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!
17 months ago
2 replies. Last post:

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

Thread 15 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?
21 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.  :)
21 months ago
Nothing New Since Your Last Visit
761
Hits

Thread 14 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).
5 years 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!
21 months ago
Nothing New Since Your Last Visit
1848
Hits

Thread 13 of 25
Thread Starter  

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

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

Thread 12 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.
34 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.
34 months ago
Nothing New Since Your Last Visit
1096
Hits

Thread 11 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
36 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
36 months ago
Nothing New Since Your Last Visit
1070
Hits

Thread 10 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.
18 years ago
Nothing New Since Your Last Visit
3697
Hits

Thread 9 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
57 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.
57 months ago
Nothing New Since Your Last Visit
3977
Hits

Thread 8 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?
57 months ago
1 Reply:

mprestwood
{Too Long!}
57 months ago
Nothing New Since Your Last Visit
2120
Hits

Thread 7 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
5 years 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.
59 months ago
Nothing New Since Your Last Visit
1954
Hits

Thread 6 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).
5 years 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.
5 years ago
Nothing New Since Your Last Visit
1750
Hits

Thread 5 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?
5 years ago
Nothing New Since Your Last Visit
1176
Hits

Thread 4 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.
6 years ago
4 replies. Last post:

Tom.K3
Thank You, that seemed to work. Tom
6 years ago
Nothing New Since Your Last Visit
2353
Hits

Thread 3 of 25
Thread Starter  

techturtle
Extracting BLOB data
{Too Long!}
7 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.
7 years ago
Nothing New Since Your Last Visit
3731
Hits

Thread 2 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,
8 years ago
3 replies. Last post:

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

Thread 1 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.,
7 years ago
Nothing New Since Your Last Visit
1796
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!

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


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