Search results for query: *

I suppose I don't have to return it to a table. I was trying to do so in order to save selections made by the user. I could save the selections to an array and/or cookies. Your link looks interesting. Thanks

I'm writing a web app (and learning at the same time) that will have daily usage by approx 100 or less users. This app will have a large variety of select statements all based on the users' selections. I want to make sure that the user's selections will not get mixed up with each other as I've...

I like the Print @SQL idea. Thanks

Never mind. I got it going. I'm new to SQL and I didn't realize SQL is sensative to spacing. It didn't like the 'dbo.' either. The following works: select @SQL = 'select statecode, statename, statenum, nstatenum, selection ' select @SQL = @SQL + 'into ' + @tablename select @SQL = @SQL + ' from...

I get the following error when I run the stored procedure below. I can't see what is wrong. It's a simple select statement into a paramaterized table. Thanks When running, it asks me to feed in a variable so I type Selstate123 Error Msg: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near...

I'm trying to learn LINQ, but it seems that regardless of what tutorial I find, nothing works. It doesn't seem to be making the back of the scenes classes. I keep getting a filenameDataContext not declared error and I have no .cs files as the northwind sample has. Anyone know what I may be doing...

I'm trying to use the wizard to set up a SqlDataSource connection. It works fine except I can't get it to update. When I get to the "Configure the Select Statement" screen and click on the "Advance" button, all check boxes are disabled for the "Advanced SQL Generation Options" screen. Can anyone...

I'm trying to visually connect a database to a grid. While configuring the select statement in the 'Configure Data Source', I select the 'Advance' button. The 'Generate INSERT, UPDATE, and DELETE statements and the 'Use optimistic concurrency' options are not enabled; therefore, I can't select...

Thank you all for your patience. I suspect I don't know enough yet in order to ask the question properly. What I'm trying to do is exactly what tsuji said in his #1 option: [1] If the static views (or even tables or columns) have names actually not beginning with @ (normal case), and that you...

If I want the name of the view to actually be a variable, then I need to use the '@' symbol unless there is another way to do this. Since this results of this view will be used for the duration of the application, I don't want users overwriting each other's views so I want a dynamic view name...

I'd like to know if this is possible and if so how do I write the code? I created a view in SQL and named it @view_selstate because I wanted the name to be a variable. I'm not sure if I can do this, but it took in SQL. I then was trying to reference it in Visual Studio VB Script i.e. if...

I installed SQL 2008 - everything except analysis and reporting. Whether I create a table or if I import tables, the database will not open and stays frozen in debugging mode when I try writing code (a simple 'use databasename') on the table. Below is my install summary. Is it because I...

I installed SQL 2008 - everything except analysis and reporting. Whether I create a table or if I import tables, the database will not open and stays frozen in debugging mode when I try writing code (a simple 'use databasename') on the table. Below is my install summary. Is it because I...

We have a marketing app that crunches data thru several select statements and a few computations and outputs a report. The app is producing different results on different machines. What would be the cause for this? We make sure we had the same exact data and the same exact executable, yet...

Hello, I've installed the Developer version of SQL 2005 on Windows 2000. All went well, but some features seem to be missing such as the DTS option, which seems to be quite valuable. For now I downloaded the SQL 2000 and works as a separate application, but not all the file types work on...

I'm transferring a desktop application to a web application. This application utilizes a lot of foxpro SQL statements, so converting this to SQL probably won't be a problem. The desktop application is written in VFP so it's not designed to be multi-user. Since user's will be making selections...

The book "MegaFox: 1002 Things You Wanted to Know About Extending Visual FoxPro" claims to cover PDF; however, I am only interested in concatenating Ghostscript. Straight forward printing in both Adobe and Ghostscript and concatenating in Adobe are all easy and I don't need a book for these. I...

Has anyone gotten Ghostscript to concatenate within VFP? If so, what was the line of code within ps2pdf used? (i.e. m_cmd = [ -q -dSAFER -dNOPAUSE -dBATCH -sDEVICE#pdfwrite -sOutputFile#]+m_outfile +[ -dnodisplay -dCompatibilityLevel#1.2 -c .setpdfwrite -f ] +m_ifilename) Is there another way...

I'd like to use the new VFP 9.0 concatenate features to concatenate Ghostscript reports. I got these working with Adobe, (Report FORM (lcReport) NEXT (mtopcnt) NOCONSOLE TO PRINTER NOPAGEEJECT) but I'm not able to get it to work with Ghostscript. Does anyone know how to concatenate Ghostscript...

Thanks for your response Mike. I mis-spoke above. It initially creates a post script file not a PDF. That is why the file has a 'nopageeject' so that I can continue to add reports before I close the file and convert it to a PDF. Report #1 doesn't work. The lcreport is simply the report name...