Recent content by Bystander

Simplistic suggestion I know but don't forget that Paradox is case sensitive. I only say this because it jumps out at me that your PKGSWEAT field is in block capitals in your code while all other fields are lower case. Is it possible that the field naming convention in your database table is...

Hi Lidia, I think I can see what might be causing the error but for me to test it out it please could you share the structure of the images.db table. Once I know what the field names are in the table I should be able to come back to you within a day or so. Regards Bystander

dpizac, Just scanning questions and noticed this one. Good to hear that you have solved it. If you ever have anything similar I suggested a solution for Pharmer a bit back. It is at thread177-1271223 titled 'Want to substitute a blank field ditto?' I hope that this helps. Regards Bytander

doronlimor, You are welcome. I was assuming that you are using the Paradox relational database application so was referring to Tools on the application main menu bar. I am srabbling about in the dark a bit here but suspect the problems are coming from a write lock on one of the tables. But I...

doronlimor, From what you set out above theoretically there should be no performance issues. Would you be happy to explain what updating the database entails. Eg is it just adding new rows or updating existing rows? What you have described sounds like a lock is being put on a table but not...

nomi1, In Word 2002 (and above I presume) ensure that your mail merge tool bar is on then go to Open Data Source - select your Paradox table - and then Insert Merge Fields - Database Fields into your Word document. Obviously that option can mean Word has access to your entire table. You may...

mwylde, I agree with TonyMcGuire you will probably have to use code to set the time stamp when records change. I presume you know that when you set up a timestamp field in a table if you set the default to NOW then everytime a row is inserted into the table it is time stamped. This however...

philly0128, If I understand the question properly then I think all that you need to do is open Paradox and then go to File - Import and follw the prompts. I hope that this helps. Regards Bystander

Bubsi, Thanks for that. I keep flirting with the idea of buying from America but will surf German sites first. Much appreciated. Bystander

Lewy, I have just noticed this and it is so long ago I assume that you have sorted it out or no longer need to. I have probably misunderstood what you are trying to do but would it not be possible to put a table frame of client details on to the tab first pane? Regards Bystander

Triedit, Thanks for the link. I know it sounds paradoxical (pardon the pun) but there is no way to buy Corel Professional from the UK supplier and you can't order from the US as UK isn't in the drop down menu. Back to the good old telephone. Regards Bystander

smartglass, Glad to be of assistance. About the logging on once, I am not sure but I think if you do the code below then you will be prompted to log in once but the database remains open for the rest of your session and all of your queries etc. I hope it works. Regards Bystander...

smartglass, Good point, I forgot to mention about type casting. Glad you sorted it out and glad to have been of service. Regards Bystander

smartglass, A way that I would approach it is to get one table to have the same data types as the other by actually programmatically restructuring the data types of the fields. For example you may wish to either look for text fields and change them to numbers or look for specific named fields...

smartglass, I'll hazard a guess that you need to be passing a string of the alias name to dbSQL.open. ie ensure that you have a Paradox alias that points to the Linux server. if Linux is the Paradox Alias then your command should be dbSQL.open("Linux",dynAlias) Let me know if you have any...