Search results for query: *

Could someone please give me an example of a simple procedure in which 2 tables have a union join and all records retrieved. The reason is I have a stored procedure to do this, which when run in the query analyser works. However I get a syntax error when trying to use this data in Crystal...

Thanks Ken, That's the conclusion I had come to here. It's just a shame this functionality isn't available? http://www.ais-lims.com

Ken, I am using SQL, I used to use DBase and I knew I could use it there. What would you suggest to get around this issue in SQL? Thanks http://www.ais-lims.com

Please help! What am I missing? I am linking from one table to two others using the same field. The section on how to handle linking two files from the one file is greyed out! I need to look up one table then the next, it won't allow me to do this! Thanks http://www.ais-lims.com

I use a database with lots of xBase tables, some have memo fields in.&nbsp;&nbsp;CR seems to be inconsistent about when I can use tables with memo fields in.<br>I have just linked to a table with a memo, I am not doing anything with that field, however I get an error opening the...

I have worked out how to do what I need.<br><br>Simple...<br><br>Place the fields one under each other in the details area, then export to a charcter seperated file.<br><br>Thanks

Thanks, however I can't get my screen to show a wide enough page to put the fields on.&nbsp;&nbsp;I must be missing something simple??&nbsp;&nbsp;I have told cr that there is no printer in page set up, no difference....<br><br>John

I would like to export data to a text file with a width of 410 characters.&nbsp;&nbsp;I can't manage to get my page width wider than say A4 landscape.&nbsp;&nbsp;How can I do this?<br><br>John

You could do a lot worse than go to CA Visual Objects.

Do your research into user profiles, local or roaming. Are people going to be moving around pc's?

I have several NT4 workstations on a Domain of NT4 Servers.<br> For no apparrent reason PC's just hang for 15-30 secs, then carry on, all at random, no matter which software is running. Everything has been fine for ages. No changes no new software.<br> Any suggestions would be gratefully...

Jono is correct about lotus notes, don't do it if you run lotus notes 4. You need administrator access to use ln4 with sp6.<br> <br> John

This is probably simple, but I don't have my thinking cap on today.<br> Imagine my table looks like this<br> <br> sample det<br> 1234 abc<br> 1234 fgh<br> 1234 xyz<br> 1235 fgh<br> 1235 ijk<br> <br> What I need to do is, say in a group footer...

I've already done that, it works. Not the best solution, but it is the easiest.

Thanks MichaelD,<br> however i don't think this is the solution.<br> The other workstations, not only don't have the same mappings but they are in different locations on different servers. Each server has the same .dbf files but with their own data within the dbf's. I want to be able to write...

How do I distribute reports to workstations that don't have the same mappings as my own? I have no problems if all mappings are the same.