Visual Basic

FirstPrevNext

Re: run access query for crystal report KIDYA14-Jul-09 0:39 KIDYA 14-Jul-09 0:39  I used code from given link....but give error "view report is not member of frmOrder" Dim Report As New frmorder Dim TableName(0) As String Dim QueryString(0) As String TableName(0) = "TableName" 'Pass The Table That you used in the crystal Report QueryString(0) = "SELECT * FROM TableName" ' Pass the Query 'ReportForm.MdiParent = MainForm 'Pass For Mdi True Report.ViewReport("CrystalReport1.rpt", TableName, QueryString, ) Data Conversion Error at RecordSet.MoveNext VB6 she-Developer13-Jul-09 22:19 she-Developer 13-Jul-09 22:19  Hi all, I'm connecting to a SQL database and reading the recordset(Rs1) sequentially using method MoveNext. This is what the data looks like: It starts reading the records fine, but crashes on 2 records which are close together in the table(input). I'm almost certan that the problem is not in my VB6 app, but something to do with the recordset, plus it doesnt seem to have anything to do with conversion. Here is the whole error message: Run-Time error '-2147467559(80004005)': SQL0802 - Data conversion or data mapping error. This happens in the line: Rs1.Movenext Please assist. Re: Data Conversion Error at RecordSet.MoveNext VB6 helelark12313-Jul-09 22:27 helelark123 13-Jul-09 22:27  It will help us if you post the problematic snippet code and in addition give more info on the fields (of table in database) type where the code is crashing. Shay Noy Windows Popup Watcher jeipiyaku13-Jul-09 22:09 jeipiyaku 13-Jul-09 22:09  Hi guys im trying do an application wherein it watches other applications activities. like for example my application will watch for any dialog box generated by the application specified in the settings. any idea on where should i start? Re: Windows Popup Watcher jeipiyaku13-Jul-09 22:16 jeipiyaku 13-Jul-09 22:16  btw im using vb.net Re: Windows Popup Watcher helelark12313-Jul-09 22:23 helelark123 13-Jul-09 22:23  Your question is to vast. You should more specify what you need, because it is complicated to answer you for this kind of question. Shay Noy Re: Windows Popup Watcher jeipiyaku13-Jul-09 22:37 jeipiyaku 13-Jul-09 22:37  thanks for your reply ok so let me make my question more specific. the core of the program is to watch a specific application for message boxes, dialog boxes, or error message boxes. then get the text from the message box then put it in a log file then preferably simulate a click event on the OK button of that message box lets say that an application generates that a message box saying that a file is missing id like to get that message then save it into a log file. hope this will explain clearly Re: Windows Popup Watcher [modified] helelark12313-Jul-09 22:49 helelark123 13-Jul-09 22:49  My question is, if I understood you right, do the "Watcher" application and the application that display the messageBox are the same one? If not, can they be the same application? If it is not same application, take a look at the following links: http://bytes.com/groups/net-vb/363935-extracting-text-another-application[^] http://www.dreamincode.net/code/snippet2117.htm[^] Shay Noy modified on Tuesday, July 14, 2009 5:14 AM Re: Windows Popup Watcher jeipiyaku13-Jul-09 23:26 jeipiyaku 13-Jul-09 23:26  nope the watcher will get the message in the message box then save it to a log file thanks for the links, will check later Database deployment. using VB .net Cory Kimble13-Jul-09 8:25 Cory Kimble 13-Jul-09 8:25  Is there a way that vb .net can help deploying a SQL database. I want a way I can create an install disc and have the user run the install disc and have the sql database with mdf files install. Does anyone know a way to do this? I know I can run the sql database installer from the setup, but how do I get the mdf files to automatically attach and be usable? I can't think of anything cool and nerdy to say. Re: Database deployment. using VB .net David Mujica13-Jul-09 8:53 David Mujica 13-Jul-09 8:53  You could write some TSQL to automate the creation of a database, logi, user, tables, views, indexes, etc, and have you clients execute the script. Commands to research: CREATE DATABASE 'MYNEWDATABASE' CREATE LOGIN CREATE USER sp_addrolemember 'db_owner','MYNEWDATABASE' Re: Database deployment. using VB .net Cory Kimble13-Jul-09 8:58 Cory Kimble 13-Jul-09 8:58  I wanted to avoid scripts. Is there a way to attach a database using vb .net code? I can't think of anything cool and nerdy to say. No scripts David Mujica13-Jul-09 9:17 David Mujica 13-Jul-09 9:17  Hmm, I must have misunderstood you. I thought you were looking for a solution to "deploy" a database. To me "deploying" a database at a client site means that they have a server waiting for you and a database needs to be created, schema created and populated, then your application can run. If all you need to do is "attach", then why can't you just have your connection string stored in a configuration file and have it load at run time. I must be missing something. "deploy" and "attach" have different meanings for us. Maybe someone else can chime in a provide a soltion for you. Re: No scripts Cory Kimble13-Jul-09 10:40 Cory Kimble 13-Jul-09 10:40  Can you help me with this? I can create database (mdf) now I need to attach it to the sql instance. How can I do that in vb .net? I can't think of anything cool and nerdy to say. Re: No experience with SQL Express David Mujica13-Jul-09 10:44 David Mujica 13-Jul-09 10:44  Sorry, I've never worked with SQL Express, just SQL 2000, 2005 and Oracle. Re: No experience with SQL Express Christian Graus13-Jul-09 10:59 Christian Graus 13-Jul-09 10:59  SQL Express is SQL 2005 with some limitations on the number of connections Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: No scripts Henry Minute13-Jul-09 11:34 Henry Minute 13-Jul-09 11:34  If you haven't already done so, download the SqlServer samples (theyr'e on CodePlex now not MS Download) here[^], select the *.zip file if you want to select where to put them, or the *.msi file if you want them installed to your SQLServer Directory. There's a shedload of useful routines, mini applications and utilities in there. The one you want isn't, from memory, but it is here on MSDN - Server.AttachDatabase Method[^] Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.” how to convert any VB.NET code into C++.net samvaidy13-Jul-09 7:41 samvaidy 13-Jul-09 7:41  I have some code and I need that to be converted into c++.net Can anybody suggest me how to do that.? Thanks. Re: how to convert any VB.NET code into C++.net Christian Graus13-Jul-09 7:43 Christian Graus 13-Jul-09 7:43  By hand, basically. C++/CLI is a bastard stepchild of .NET and C++, so I doubt there's tools to do it, like there is for C# and VB. However, if you can build your VB into a dll and call it from C++/CLI, that would work fine. Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: how to convert any VB.NET code into C++.net samvaidy13-Jul-09 10:00 samvaidy 13-Jul-09 10:00  Thanks Re: how to convert any VB.NET code into C++.net Luc Pattyn13-Jul-09 8:10 Luc Pattyn 13-Jul-09 8:10  or, for a small app, you might consider using Reflector to peek into the VB.NET class(es) and copy the MC++ equivalent code from there. This would loose local variable names and comments of course, but it does allow you to avoid a separate dll file. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem. Re: how to convert any VB.NET code into C++.net 0x3c013-Jul-09 9:13 0x3c0 13-Jul-09 9:13  I think there's also a plugin somewhere which allows you to do that with every file. I've used it before, but can't remember the name Between the idea And the reality Between the motion And the act Falls the Shadow Re: how to convert any VB.NET code into C++.net samvaidy13-Jul-09 9:59 samvaidy 13-Jul-09 9:59  Thanks guys...I will try to work out onn that. Re: how to convert any VB.NET code into C++.net Dave Doknjas13-Jul-09 14:13 Dave Doknjas 13-Jul-09 14:13  We produce a product for this (Instant C++ VB Edition). It has a free demo edition which will convert 100 lines at a time. David Anton http://www.tangiblesoftwaresolutions.com Convert VB to C#, C++, or Java Convert C# to VB, C++, or Java Convert C++ to C#, VB, or Java Convert Java to C#, C++, or VB How to use special symbols in VBA? Ton C13-Jul-09 6:10 Ton C 13-Jul-09 6:10  I want to use Polish letters like ż, ł, ą, ę, ś, ć, and of course the capitals. VBA doesn't accept the normal "ALT GR +"-combination. Copy/Paste also doesn't work. Please can somebody advice? With kind regards, Ton C.

Last Visit: 31-Dec-99 18:00     Last Update: 26-Jul-24 15:03 Refresh ᐊ Prev1...1003100410051006100710081009101010111012 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.