Search results for query: *

I just want to print simple labels. There will be two parameters; the starting number and the ending number. I just want to print out labels starting with the first parameter and continue printing, incrementing by 1, until the second parameter value is reached. Mike

Scenario Parameters passed to report are min = 1 and max = 4 Rec 1: Cust A Rec 2: Cust A Rec 3: Cust B Rec 4: Cust A This is not usually going to occur and for printing it isn’t a problem. The reports need to be printed in the original order entered. Not sorted by customer. Problem : I...

I have a stored procedure that inserts records into a table that is about 600,000 records in size at this point. This stored procedure is called recursively from a middleware application that reads a text file and calls this procedure for every line of the file that has valid information. At...

Can anyone tell me why the value of @var2 can be used to execute a query but the value of @var1 cannot? Is there anyway to force sql server 2000 to recognize the value in @var1 instead of trying to read this as a column name? declare @var1 varchar(50) declare @var2 int select @var1 from...

Can anyone tell me why the first works in a sp and the second doesn't? 1) CREATE PROCEDURE w_z_testing AS create table #t_table (f1 int, f2 int) alter table #t_table add f3 int insert into #t_table (f1, f2) values (2,3) select * from #t_table GO RETURNS: (1 row(s) affected) f1 f2...

I do not know if it is possible to do. I’m using version 9. I would like to lock the page header and footer sizes on a report template so any reports made from that template will look consistent. I do not want other report creators to be able to increase or decrease the height of the sections...

CREATE PROCEDURE testdynamtable AS set nocount on declare @tmpcolname varchar(20) set @tmpcolname = 'col1' create table #tmptable (@tmpcolname int) ^ | How do I do this? GO Mike

Can anyone help? This seemed like simple task at first. I have a table f1 | f2 ---------- xx | 11 yy | 22 zz | 33 I want to select all rows but have the current record to be somewhere other than the first record. Do I use a index seek function and if so what is the syntax...

First let me describe the system I am working with at work. WAN -> DSL Modem -> Sonicwall firewall -> Win2003 VPN sever -> LAN. When I connect through a dial-up connection everything works fine. I can browse the network at work and even log onto my NetWare server. I might also need to mention...

Does anyone know of any pervasive engine (O.S. Novell Netware 5.1) settings that may need to be changed to increase performance? We have an in-house app that uses pervasive 2000i sp4 (transactional only) but we have just added the accounting package ACCPAC that, I’m assuming, is using relational...

I need some advice on how to make my frames work correctly with a login script. Ok here is what I want to happen. I have some ideas but wanted to know the best way of doing this. I have a menu frame with a login link to direct the main frame to a login page. That is no problem. But after a...

I’m new to php so keep that in mind when you read my question(s). What, if any, is the difference between; $myvar = “Joe Blow”; $outputstr = “The user is $myvar”; , $outputstr = “The user is “.$myvar; , and $outputstr = “The user is “; $outputstr .= $myvar; ? Another question I have that...

Upgrade Advantage? OK here’s the deal. I have reports in version 9 and I would like to convert them back to version 8.5. I do not know if this can be done but if anybody knows of a way or a utility that can do this please let me know. My bad. I should have researched a little more before...

Can anyone tell me how to print a report to a file without being prompted for the file name? I am using the report designer components in Delphi, if that helps any. I cannot find anyway within CR9 to set the printer output to a file. I want to be able to print to file using the printer...

Can anyone tell me a quick and easy way to flush the keyboard buffer without having to make a low level call or calling a dll. I am prompting with a, recursively called, yes - no message box and I do not want the user to be able to accidentally hit the space bar or enter twice. I want to flush...

I’m reading a simple text file and parsing the lines into an Excel 2000 worksheet. I’m using VBA (obviously) and the InStr function to return the positions for the Mid function. I have tried both of these and other variations of, to return the substring of number characters after the “$”...

How can I call a dial-up connection from a VB6 application then get the IP from that connection? I can get the IP from my NIC from the winsock component but I want the dial-up IP number instead. Mike

Can anyone tell me where MS Backup is in XP Home edition? Mike

I’m sure I know the answer to this but I am going to ask anyway. Can anyone give me a clear definition of the difference between the workstation engine and the workgroup engine? Also clear examples were each might be the better choice. Mike

Using the winsock control; if a machine has more than 1 IP is there any way to retrieve all of the IP’s? Or maybe to specify which adapter to retrieve the IP from? Thanks in advance for any help. Mike