Search DaniWeb - statement

VB60, Run-time error 3709 solution 1 Month Ago by Julius_10 Resolution of error "Run-time error '3709'" at make-table from sql select statement Re: Improve HAVING BY performance 2 Months Ago by toneewa … 8 sql::mysql::MySQL_Driver* driver; sql::Connection* con; sql::Statement* stmt; int ct = 0; int main(){ while(ct…quot;); con->setSchema("electronics"); // Create a statement stmt = con->createStatement(); auto start_time0 = std::chrono… Re: Improve HAVING BY performance 2 Months Ago by Biiim … the same! That said, I mean't that the HAVING statement is like dumping your query result into a temp table… Re: Video is not the main content of the page 1 Month Ago by Read a Book But i am generating the JSON code dynamically. If there is no video than i hide the VideoObject tag with if statement. Should i just remove the `itemscope itemtype="http://schema.org/VideoObject"` Re: What's the most unexpected hobby or interest you have outside of coding? 1 Month Ago by Dani …, ChatGPT has done an awesome job at solving the problem statement I tasked it with, which was to come up with… Re: And so the cookie crumbles... 2 Months Ago by Dani > My decision were based on the "arrogance" of some moderators, it seemed that the entire site moved away from being a community service to a "I am the boss, do as I say" environment. AndreRet, based on your [latest post](https://www.daniweb.com/programming/databases/threads/541622/improve-having-by-performance#post2296496… Re: Why does Dell hate Linux so much? 2 Months Ago by mickeydoodle I've just acquired a Dell laptop, it seems to hate Linux! Touch pad doesn't work properly, Wireless won't connect and it's sooo slow! Works fine with Windows! Re: VB60, Run-time error 3709 solution 1 Month Ago by Reverend Jim Are you trying to execute the query before opening the connection? I'm just guessing because you didn't post any code. Strictly speaking you didn't post a question either. Re: VB60, Run-time error 3709 solution 1 Month Ago by rproffitt Our old VB6 SQL apps began failing a few years ago. We hadn't worked on those for over a decade along with decommissioning the developer kits. Turns out the company using these had moved to Windows 10 which didn't exist back when the apps were developed or put into service. We are still in negotiations about replacement apps along with … Re: Why does Dell hate Linux so much? 1 Month Ago by simhakidsden It's quite baffling to witness such a stark contrast in Dell's approach to promoting Ubuntu between Europe and the USA. Their inconsistent messaging only adds to the confusion for potential customers. Hopefully, Dell can streamline their marketing strategy to provide clearer information and support for Linux enthusiasts worldwide. Re: VB60, Run-time error 3709 solution 4 Weeks Ago by mdv3441 You can still install and run VB6 in Windows 11, when installing you will get an error dealing with some data piece, you either skip or not install it. Be sure to get VB6 Service Pack 6. There are many of us still supporting and modifying VB6 programs, As far as the Error goes either the Server name is wrong or isn't yet connected like the … Re: VB60, Run-time error 3709 solution 4 Weeks Ago by mdv3441 Sorry, not sure where you can get a copy, several showing up on Internet who knows if legit. I thought maybe you have copy, just couldn't get installed. Like I mentioned many of us have vb6 development systems. If you wish one of us could help if you have the source code to the program. Mike Re: VB60, Run-time error 3709 solution 4 Weeks Ago by rproffitt For mdv3441. While we still have the VB6 install media and know about service pack 6 and more, it's all for naught as the key SQL component is dead now. Yes we could do a re-write but as the client won't pay for the updates they are left as-is. We're ready to move to the latest Visual Studio but VB6, dead and we can't obtain licenses from … statement 14 Years Ago by carsein …'t really find the solution. Hope anyone can help. What statement should I write for this:There is a table of… statement help 14 Years Ago by manutd4life Am getting problem with this update statement: Here's the code: [code=vb.net]Private Sub cmdUpdate_Click(… Statement stmt syntax errror 14 Years Ago by ceyesuma …= 0; i < schoolofdbTables.length; i++) { Statement stmt = null; temp = null; String temp = …table: " + temp); try { stmt = (Statement) conn.createStatement(); stmt.executeUpdate(temp); stmt.close(); bCreatedTables … Statement not being executed in source 12 Years Ago by berniefitz … am currently struggling through trying to figure out why a statement in my source code isn't being executed when running…[row, 7].Value + taxableValueDifference; The first and last statement execute, but the middle statement is just skipped. Any ideas as to why… statement adding extra space 19 Years Ago by shanenin … tax is: $",base_price+under_coat+stereo+air+tax[/code] this statement is not behaving in the way I think it would… Re: statement adding extra space 19 Years Ago by vegaseat The comma will automatically add a space. Better use this formatted print statement: [php]print "the total price of the car with all extras and tax is: $%d" % (base_price+under_coat+stereo+air+tax) [/php] statement to open new url and close calling page. 15 Years Ago by squarkman … morning. I would like to replace line 178 with a statement which would simply open a new url and close out… Re: statement to open new url and close calling page. 15 Years Ago by squarkman Thanks! Wonder why it's called header. What's it got to do with a header. It's a statement that will open a url inside php. Someone said it could not be done. Re: statement 14 Years Ago by VIeditorlover Are talking about a form of soft realtime? Please try to explain why is 3s limit so important for you, maybe it would be much easier to help you. Re: statement 14 Years Ago by carsein I mean the difference between timestamp is 3 sec(or any given value). Re: statement 14 Years Ago by VIeditorlover So you have many records and you want to see only pairs of rows created in less than 3 sec time window, right? Re: statement 14 Years Ago by carsein yes.. Re: statement 14 Years Ago by sknake Try this: [code=sql] --Create a simulation table IF OBJECT_ID('ParcelTest', 'U') IS NOT NULL DROP TABLE ParcelTest Create Table ParcelTest ( ID int identity(1000, 1) PRIMARY KEY, ShipDate DateTime, Name varchar(30) ) GO --Create test data Declare @DateTime DateTime Set @DateTime = Floor(Cast(GetDate() as float)) Insert Into … Re: statement help 14 Years Ago by sknake That all depends on what your final query is evaluated as. We can't see what your user input is. One piece of advise: [b]use parameterized queries![/b] [url]http://forums.devx.com/showthread.php?t=160026[/url] Put a break point on the line [icode]com.ExecuteNonQuery()[/icode] and evaluate the value of [icode]com.CommandText[/icode] and post it … Re: statement help 14 Years Ago by kvprajapati @manutd4file : error saying (no value given for one or more required parameters) --- Compare columns names with your fields (columns) of database's table. Re: statement help 14 Years Ago by padtes As suggested by Scott Knake, find what the final SQL is, copy that and paste in query analyzer to see if that by itself. Syntax error given there are more informative. Other thing he suggested is paramterize your query. Otherwise, data with single quote will bomb the query, worst yet, it is prone to security flaw (google SQL injection) Re: statement help 14 Years Ago by yorro Try displaying the SQL as a Label in your form to see if some of the txt.Text is null.