Search results for query: *

I tried that and get same error, the "vbCrLf" gives me blank lines in the data file. Should I try to write a blank line with "vbCr" as content after I have filled all mydata?

I still get "Unexpected EOF encountered in data file" VB: Dim content As String = ticket_date & "\t" & job & "\t" & job_phase & "\t" & tons & vbCr IO.File.AppendAllText(absolutePath, content + Environment.NewLine) SP: CREATE PROCEDURE MyJobs @PathFileName varchar(100), @Return int =0...

Here is what I have: [code] Dim content As String = ticket_date & "\t" & job & "\t" & job_phase & "\t" & tons & "\n" IO.File.AppendAllText(absolutePath, content + Environment.NewLine) [code] My sp: [code] CREATE PROCEDURE MyJobs @PathFileName varchar(100), @Return int =0 output as If...

Do I need a row terminator as well?

I'm doing a bulk insert from a text file and get error: Bulk insert: Unexpected end-of-file (EOF) encountered in data file Here is my sp: CREATE PROCEDURE MyJobs @PathFileName varchar(100) as If Exists(Select * From Information_Schema.Tables Where Table_Type = 'Base Table' And Table_Name =...

I have a datagridview that does not allow to resize columns. I have tried to set properties but cannot get it to work. Can anyone tell me what is wrong? 'DataGridView1 ' Me.DataGridView1.AllowUserToAddRows = False Me.DataGridView1.AllowUserToDeleteRows = False...

I have a windows form that displays a data grid and a crystal report. How Can I add a 2nd (new) report to the form or will this have to be a sub report off the main report? I tried to add a totally new report but it gave me errors when I tried to rebuild the project. Any litterature out there...

I just have one report and the tab takes up too much room.

Does anyone have a quick solution for disabling the "Main Report" tab?

Found the solution: MyCrystalReportViewer.DisplayGroupTree = False MyCrystalReportViewer.ShowGroupTreeButton = True

I'm using crystal report in my vb application, binding it to a data set and displaying the report. When I display the report, the left part of the report is blank (navigation section??), it looks like the report is split in two parts. This part consumes too much space of the screen. How can I...

I have an application that reads from a data base table and fills a DataSet and consequently binds to a DataGrigView. Now I need to add a Crystal Report Viewer to the same form and display the query result. I have defined my data set in the code (no user controls from tool box). When I try to...

Thank you, it worked...

I'm trying to drop a table and get error. I've tried to use the 'If Exists..." but cannot get the syntax to work Error: Cannot drop the table 'JobTable', because it does not exist in the system catalog. CREATE PROCEDURE sp_CreateJobTable as DROP TABLE JobTable create table JobTable ( job_date...

George: If I create a real table how can I preserve integrity if several users are running the program at the same time? If I create an ASCI file how will I be able to extract each field element when I bulk load it into a temp table? It seems to me that creating an xml document is the...

George, Thank you for the offer. Very nice of you. Please note that the plants are NOT running sequel server, they are running Advantage data base server (http://www.extendedsystems.com/web/content.aspx?key=79D35E8C44D23A8EA9BB2E0A5A8536A2). Have their own drivers etc I am to the point wher...

Maybe I could use table variables?? CREATE PROCEDURE sp_UpdateJobTable ( @parm1 datetime, @parm2 char(15), @parm3 char(15), @parm4 int ) AS DECLARE @jobtable TABLE ( job_date datetime, job_number char(15), job_phase char(15), asphalt_delivered...

First, sorry for my lack of knowledge and thank you for your help. Business scope: We have 8 asphalt plants that delivers asphalt to road paving jobs. The delivieries are recorded a what we call sales ticket table for each plant. These plants run on Advantage data base. Eigth different servers...

I'm afraid it will go out of scope because of what I need to do: I have 8 data bases and one table in each of these that I need to read: So, I open connection to 1st db, loops through a data reader and calls the sp, then I close connection. This is repeated 8 times. I thought this would take...

Here is what I've tried: I have an application that: 1. calls a sp and creates a temp table 2. reads a table using data reader 3. updates the temp table. When I update the temp table I get an error: Quote: System.Data.SqlClient.SqlException was unhandled Class=16 ErrorCode=-2146232060...