Search results for query: *

This is the entry in a CL program. 0109 represents month and year. I want to automate that using a system date or some other source. How can I do that in CL? IF not, RPG? How? CPYF FROMFILE(#FILE/CHRG) +...

I am looking into some tools to monitor users and client machines for changes to a database(s). I need something capabale of reporting on inserts, updates, deletes, table and metadata changes etc... More the merrier. So far I have tried evaluations of Omni-Audit, Hallogram SQL Audit, and...

I have a problem printing using wordperfect 11 and windows xp pro. When I want to print a document it sends the job to the spooler and the status says spooling for more than 45 seconds before it actually prints. There are no graphics in the document just three words. It only does this in...

You rule, aussie! Thank you very much!

It is a jpeg. Can post a sample vb code to do this? I never tried to write vb yet but it is time now! Thanks!

Let say I have a table with images. How can I export them to a folder c:\images using the {primary key}as the name with the extension .jpg ex. id image 1 010101 2 010101 3 010101 as 1.jpg 2.jpg 3.jpg

Thanks otto! I had run a perl script at interbase to get my results since I had a time frame involved. I tried the UDF's on some other test data and suprisngly they work pretty good on data manipulation. Great advice, Thanks! I didn't know that existed... FYI for the PERL: use DBI; use...

Hello ISQL people, This is probably an easy one but I'm finding it difficult since I am not too great at ISQL. I have a field that contains phone numbers and want to delete the ( ) -. ex.. (212)555-1212 needs to be 2125551212 I can do this in T-SQL as update stage_guest set phone =...

Nevermind! I figured it out... FYI Update table1 set table1.f1 = select table2.f2 from table2.f2 where table1.key = table2.key

Have you looked at cross tab reports?

How do I update a field in (table A) using data from a field from (table b) in the same database? The transact sql statement does not work in ISQL. Help!

I took it all down and removed any remnants in the registry since a standard reinstall didn't work. Reinstalled and recreated the system objects and is now working. Although I didn't have to call replication technologies thanks for the ups...

You can make the header, group or detail fit the whole page since only one of the criterias will show. I can't think of a easy way to tile right off the bat. Maybe some wiz in here has a solution to this but, here's my 2 cents. Quick and easy, take the small graphic and create a tiled...

I could think of a couple of ways to do this. 1. You create a new section under detail,,, defaults to detailb and copy the details from detaila to detailb so that they are the same. Insert your paid watermark in detailb. Make sure you underlay this. Now go to section expert (right click...

I have installed IBReplicator and has been working perfectly for about 2 years. The timer is set to replicate every 5 minutes but now it does not replicate automatically. Any clues?

Thanks MartijnTonies! I appreciate the effort. Version 7 has this capability? Sweet. I better get started on a test environment. Version conflicts maybe a whole can of worms. Thanks again.

Sorry, "pegging" meaning the cpu usage is at 100% in the performance monitor on NT and "getting slow". I have ibreplicator pulling data on another server, I have a telephony system and a web based reporting tool running queries, and 150 clients doing updates and inserts...

I have an issue with our server pegging from time to time. I have Interbase 5.6. I'm not sure if it is a bad query or process. Does anyone here know of any tools available to monitor logins and their activities so that I can pinpoint the problem. Your help will be greatly appreciated...