Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zilxodarap

    Paradox to mysql - what would you use for the front end?

    OK, just for fun, I did a google search and this result looked rather interesting: http://www.wedge.coop/is4c/ FWIW, Liz
  2. zilxodarap

    Paradox to mysql - what would you use for the front end?

    Kit, Unfortunately, I don't work in an industry like yours, so any program I named would come from a google search - which I'm sure you can do more effectively yourself. That said, POS applications for brick & mortar establishments are numerous (just look at the number of stores one can walk...
  3. zilxodarap

    Paradox to mysql - what would you use for the front end?

    Kit, I haven't had problems using ODBC drivers with Paradox to access non-Paradox databases. But I've never used them for more than importing / exporting and similar short-use purposes. There are others, however, who have and are using Paradox to access external databases and I don't know of...
  4. zilxodarap

    Paradox to mysql - what would you use for the front end?

    Kit, If I understand correctly, you have three stores in three separate locations. You want all three of them to share a single database/application. It seems to me, a browser-based application (meaning, one that runs in a web browser (aka a web site)) is what you want. What programming...
  5. zilxodarap

    Question on Queries

    If it's a Paradox table (.db file), a blank field is blank, not NULL. SO: SELECT * FROM table WHERE field='' ...would get you everything where that field is blank. Liz
  6. zilxodarap

    Minimum RAM?

    First, 4*M*b of RAM or GB? If MB, I can only assume you're running DOS? Are you getting an error, or just incorrect results? Show your code / calculations and some sample values, what you expect and what you're getting. It could be corruption, it could be misunderstanding of what's possible...
  7. zilxodarap

    MS Server 2008 & Paradox 9

    Just some thoughts. I haven't tried using MS Server 2008 as a file server. 1. There's no reason a TCP/IP network would work. Go with that. 2. Turn off opportunistic locking. 3. Turn off real-time anti-virus scanning for all directories used by Paradox - both on workstations and on the...
  8. zilxodarap

    Unable to Export Paradox Table into 2nd WordPerfect

    Never tried doing what you describe, but try this: 1. Make sure Paradox and WordPerfect are closed. 2. Search for paradox.lck and pdoxusrs.lck (they will appear in directories where Paradox tables live and may be "left over" if Paradox closes abnormally) 3. Fire up WordPerfect and try to...
  9. zilxodarap

    Question on Queries

    Paradox tables can't have NULL values, so, no, the row isn't dropped. If you're using a plain checkmark (not checkplus), then one record for each unique combination of values in the checked fields is returned. Liz
  10. zilxodarap

    How to make all tables "read only"?

    There's an easier and better way. Create directory locks. (If you set the directory to read-only, Paradox won't be able to create the lock files it needs; if you set the files to read only, Paradox may give an error (not sure); but it should recognize directory locks and then only edit...

Part and Inventory Search

Back
Top