Search results for query: *

Hi, Sorry - I did not copy the entire text. I do have closing tags. I tried with Firefox but will give IE a try and see if it helps. Any other thoughts? KC

Hi, I have a php page that pops up a print window - also a php page. In the pop up page I have the following code which I was hoping would enforce a page break when printing, but it does not: <tr><td width=100% colspan=4>&nbsp; <hr size="5" noshadow> <p...

The problem is that I don't know what the column names are. Is there a way to view the original column names? For the most part I can't tell by the data because the file names are not very descriptive to begin with. I also encountered another problem. I tried to look at the data via MS...

Thank you - I actually got a lot further yesterday. Most of the files are not defined in the dictionary. So I used DDF Ease to create a new database and then created some of the files in this new database. Once I did that I was able to view the data with MS Access via an ODBC driver. It's a...

I also get the following error message when trying to link the table: Scalable SQL cannot open the data file to retrieve the file statistics (#296) In DDF Ease I get the following error: DDF Ease encountered Btrieve error 12 when trying to access [directory/filename]. the directory listed in...

OK, so now I am able to create a system dsn and I can see tables when using the dsn via Access. However, some of the files that have the most records in them, do now show up in the list tables. Does that mean they have not added them to the dictionary? If so, is there a way for me to add them...

The DDFs are definitely on the server. I am not sure about teh SQLSTART command however. How would I know whether it has been issued or not? Do I need to be at the server or can I connect to it remotely and issue the command? Thanks, Kristina

I tried BtSearch32 but could not see the files that contain the data. Also, my company would prefer a 0$ solution if at all possible. Thank you, Kristina

Hi All, We were running a 3rd party application against a Pervasive SQL 7 database on a Novell server. We have terminated our contract with the software vendor but would like to pull the data out – without asking the software vendor. I tried to establish an ODBC connection (User DSN and System...

This is what I get: HP TCP/IP Services for OpenVMS Alpha Version V5.4 on a COMPAQ AlphaServer DS20E 666 MHz running OpenVMS V7.3-2 Thanks, Kristina

We are running OpenVMS V7.3-2 but I am not sure on the TCP stack and version. How would I go about finding out other than asking our network administrator?

Hi All, I have a batch job that runs several quiz extracts. When all the extracts are done running, I would like to FTP a file to our Linux box. Is this possible and if so, how? Thanks, Kristina

Hi Dave, I actually just found a solution and part of the problem. There are three Provider tin nums in this file (PCP, SVC, and Primary) but in the catalog the names are TIN_NUM, TIN_NUM_02, and TIN_NUM_03. TIN_NUM_02 in my report should have actually been TIN_NUM. Once I changed it I got data...

Hi Dave, Sorry for the confusion. I posted the SQL statement without the outer join and without the additional filter because neither one were working for me. I want the outer join on: AND T5.TIN_NUM = T1.TIN_NUM_02 AND T5.SUB_TIN_SEQ_NUM = T1.SUB_TIN_SEQ_NUM_02 T1.TIN_NUM_02 as well as...

Hi Dave, Thank you for the reply. Yoy have been very helpful and I appreciate it. We have OpenVMS 7.3-2 and I am using an CONNX ODBC driver to connect to it. One of the first things I tried was adding the "OR field is null" to my statement, but the report runs "forever" and my entire machine...

Well, I think what I am doing is correct, it's just that it doesn't like my (+) in the statement. Here is my scenario. PRV - Provider Info NAME TIN_NUM SUB_TIN_SEQ_NUM UMD - Hospital/Patient Info SVC_TIN_NUM SVC_SUB_TIN_SEQ_NUM PCP_TIN_NUM PCP_SUB_TIN_SEQ_NUM I use the PRV table twice. Once...

Hi Dave, I guess I am somewhat confused. There are other tables joined to the outer joined table. What I don't understand is how to review the filter clause in the report. Because I modified the SQL, I cannot get back to the original tabs I used to have. Or is there a way I can change the...

I forgot, we are using version 7.1.339.0

Hi All, A while back when I was totally new to Impromptu I changed the SQL on a report. I had no idea I would not be able to go back to the original format (unless you can and I am not aware of it). I did this in order to join the same table twice and at the time I did not knwo how to modify...

Me again - I got it to work. Please disregard the original message. Sorry!