A Google would have been quicker. DuckDuckGo would have been quicker. This is not a tech-secret or anything comparable, there's quite a lot of copy and paste code out there doing just what you asked. And you didn't find it. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I'm really sorry not being able to give you a good solution for this problem you are describing. However, I recommend you going to the tech forum on Craiglist. You could find an answer over there.

Your POS talks to the database via a "Protocol" (look it up you need to learn what it means.) There are a couple of ways to do that but the primary one for a distributed system these days for everything is via TCP/IP. That is what you are generically referring to as the "network". You should try to read something, just a little bit, on how TCP/IP works since that is also something you need to know. Your POS is a "client". The SQL Server is a "Server". Those terms are relevant in TCP/IP. There is a "connection string" which is defined in a configuration source, which will almost always be a file. So you need to learn about that "connection string" and how to configure it. To create the correct connection string you will need to know either the "host name" or the "IP Address" (which is something you learn about in TCP/IP) to specify how your "Client" will find the "Server". You can google for examples of SQL Server connection strings and also examples about how you set it up.

I am not sure why you are converting to CHAR(10) when you are looking for a date comparison/ What you are converting is your b.startup_chack_date value. If that is already a date then it does not need converting. For the meaning of the 120 (and other values) see, for example, <a href="https://www.w3schools.com/SQL/func_sqlserver_convert.asp">[^]

The PM deserved it. They are a blight upon society

It's been a long time since I have used it so I don't remember any specifics but it sounds like either the sql is not being executed or it is and it's not returning data. Try using Sql profiler on your database to see if any sql is being executed.

..but not exactly simple; a server, and launches a service-process. Also a bit larger than SQLite. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I think I figured it out. What I'm trying to get is the column names in the meta data of the table. The example use a foreach loop, so now I know how to use foreach in PHP V7+ Seems needs some work and polishing. public static function dbSelectQuery($sqlQuery): array { // print\_r(debug\_backtrace()); $Rows = array(); $rgFields = array(); $params = array(); $options = array( "Scrollable" => SQLSRV\_CURSOR\_KEYSET ); $conn = clsDbConnect::createConn(); $resQuery = sqlsrv\_query($conn, $sqlQuery, $params, $options) or die(" cls\_db\_tools 128: " . $sqlQuery . print\_r(sqlsrv\_errors()) ); $rowCount = sqlsrv\_num\_rows($resQuery); $fieldCount = sqlsrv\_num\_fields($resQuery); $cIndex = 0; foreach( sqlsrv\_field\_metadata( $resQuery ) as $fieldMetadata ) { $columnName = $fieldMetadata\['Name'\]; $rgFields\[$cIndex\] = $columnName; $cIndex++; } for ($i = 0; $i < $rowCount; $i++) { $row = sqlsrv\_fetch\_array($resQuery,SQLSRV\_FETCH\_NUMERIC); for ($col = 0; $col < $fieldCount; $col++) { $Rows\[$i\]\[$rgFields\[$col\]\] = rtrim($row\[$col\]); } } sqlsrv\_free\_stmt($resQuery); return $Rows; } If it ain't broke don't fix it Discover my world at jkirkerx.com

Oh that works! I would figured it out eventually, maybe within 3 months ;) Just read the link, did not know that. I was thinking perhaps I had to preprocess that variable before echoing it out to the presentation layer. Well that solves another 500 errors in this project, about 1000 more to go. Thanks Richard, really appreciate the help. This project is really beating me up mentally, but it will be worth it in the end. If it ain't broke don't fix it Discover my world at jkirkerx.com

We figured out what it was - database permissions. F*ckin DBA's... ".45 ACP - because shooting twice is just silly" - JSOP, 2010 ----- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010 ----- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Additionally, the downvotes might be related to bad spelling, bad formatting, wrong grammatic and specially with the impression you give, that you don't give a crap about the quality and correctness of your posts. An don't get me wrong, I can understand if you are not a native english speaker, because neither I am native speaker. But only because you can't speak well a language, it doesn't mean that you can't try to speak that language properly. M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

The red flag is always available, in all post types. M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

I read OCD and immediately thought about how I dropped a tea mug about a year ago and now have an uneven number of tea mugs in my house, which still bothers me. 2020 really was a tough year! :sigh: Best, Sander Azure DevOps Succinctly (free eBook) Azure Serverless Succinctly (free eBook) Migrating Apps to the Cloud with Azure arrgh.js - Bringing LINQ to JavaScript

It doesn't. It simply updates the DueTime column in the PendingQueue table, and returns the Payload and id columns of the affected rows. There must be some other code which processes and removes the record from the PendingQueue table which you haven't shown. "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Mou_kol wrote: i read about ROWLOCK & UPDLock but still not clear MSDN pretty clear. Bastard Programmer from Hell :suss: "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.