Search results for query: *

Thank you!

I'm not sure if this is the correct forum for this. HP Laserjet 3015DN - HP Universal Print Driver. Edge to edge is turned on, but it's still cutting off right hand side of the form. Any idea why or any recommendations on fixing this? Thanks in Advance!

That is absolutely perfect. Thanks!

I have a select query with a subquery as a column: select name, (select count(*) from children), address, city from parents John, 2, 123 Johnson St, Chicago Fred, 0, 456 Jackson Ave, Chicago Mark, 1, 789 Jordan Rd, Chicago This is a dummied down version of what I need to do. But what I want...

Does anyone know? Please?

I am trying to setup a batch file to check out a file using the "Don't get local copy flag". Looks like this would be -L (or -L+ or -L-), but I can't get any of the flags to work. It tells me that it is not a valid switch. Can anyone help?

Outstanding. You guys are awesome!

Can I suppress the "(1 row(s) affected)" message caused by "insert into @db_name_table" lines? I only get it on text output, but that's what I prefer. Not a big deal, just wondering if there's an easy fix.

That's exactly what I was wanting. Thank you so much.

Thanks guys. Still not quite what I'm hoping for. The sp_MSForEachDB seems to be closest to what I'm wanting, except that I'd like to be able to define the databases I run the script on, instead of running it on ALL databases. There may be 10 databases on the server, but I only need to run...

Please let me start by saying I really don't know the syntax for SQL scripts when it comes to variables, loops, etc., so my example code I'm sure isn't close to what I need. Could someone share with me the syntax to run a SQL script against an array/list of databases. So instead of doing...

I did see it, but did not notice that you did the embedded sql with the join also. I saw the select and assumed you were giving me something I wasn't wanting. So I will take the blame on that one and give you a star as well. Sorry about that. If I'd looked at yours more deeply I probably...

Thanks a million. Wasn't exactly what I needed, but definitely gave me the structure I needed with that embedded select statement.

Thanks, but I messed up a little. I just want to update the original table, but change the records for "fred" to match what's in the table for "matt". I wasn't specific enough. I apologize

current table: key formname userid fieldname x_coor y_coor --- -------- ------ --------- ------ ------ 1 form1 matt field1 1 1 2 form1 matt field2 100 1 3 form1 matt field3 200 1 4 form1 fred field1 5 50 5 form1 fred field2 500...

Beautiful. I think that's sufficient. I'll be back if I get stuck again, but this is what I was looking for. I was missing the database driver and the SET command. What exactly does the SET command do?

I am trying to read an ASCII file in Clarion 6.3, and I'm having a little trouble with it. I've tried 2 methods, one where I define the file using FILE,DRIVER('ASCII'... and one using the AsciiFileClass, but I can't get either to work for me. Could someone please give me some very simple...

Indeed I did. And I'll also try out the command prompt using .bat files to see if I like it. Thanks!

I had my .dtsx files built and I could run them by just running the .dtsx file. However, somewhere along the way, Windows (XP) has lost the file assocation for the .dtsx files, now I can't run them - I have to pull them up in Visual Studio to run them. What program do I need to point the...

Thank you so so much.