{"id":8405,"date":"2016-07-01T16:57:03","date_gmt":"2016-07-01T08:57:03","guid":{"rendered":"http:\/\/www.vbtutor.net\/?p=8405"},"modified":"2017-10-06T21:43:56","modified_gmt":"2017-10-06T13:43:56","slug":"using-sql-queries","status":"publish","type":"post","link":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/","title":{"rendered":"Using SQL Queries in Visual Basic 6"},"content":{"rendered":"<p>After creating a database in Visual Basic 6. we can write code to allow the user to \u00a0to search for a certain information using SQL query. SQL stands for <b>S<\/b>tructures <b>Q<\/b>uery <b>L<\/b>anguage. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria. The syntax of a SQL is as follows:<\/p>\n<p><b>SELECT fieldname1,fieldname2,&#8230;..,fieldnameN\u00a0 FROM\u00a0 TableName<\/b><\/p>\n<p><b>SELECT\u00a0 * FROM\u00a0 TableNam<\/b><\/p>\n<p>Learn more about SQL from the link below:<\/p>\n<p><a href=\"http:\/\/www.vbtutor.net\/lesson27.html\">http:\/\/www.vbtutor.net\/lesson27.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>After creating a database in Visual Basic 6. we can write code to allow the user to \u00a0to search for a certain information using SQL query. SQL stands for Structures Query Language. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria. The syntax of a SQL is &hellip; <a href=\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Using SQL Queries in Visual Basic 6<\/span><\/a><\/p>\n","protected":false},"author":23013,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,1],"tags":[],"class_list":["post-8405","post","type-post","status-publish","format-standard","hentry","category-latestnews","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB\" \/>\n<meta property=\"og:description\" content=\"After creating a database in Visual Basic 6. we can write code to allow the user to \u00a0to search for a certain information using SQL query. SQL stands for Structures Query Language. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria. The syntax of a SQL is &hellip; Continue reading Using SQL Queries in Visual Basic 6\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Vbtutor\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-01T08:57:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-10-06T13:43:56+00:00\" \/>\n<meta name=\"author\" content=\"Liew Voon Kiong\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@liewvk\" \/>\n<meta name=\"twitter:site\" content=\"@liewvk\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Liew Voon Kiong\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\"},\"author\":{\"name\":\"Liew Voon Kiong\",\"@id\":\"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d\"},\"headline\":\"Using SQL Queries in Visual Basic 6\",\"datePublished\":\"2016-07-01T08:57:03+00:00\",\"dateModified\":\"2017-10-06T13:43:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\"},\"wordCount\":85,\"articleSection\":[\"Latest News\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\",\"url\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\",\"name\":\"Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB\",\"isPartOf\":{\"@id\":\"https:\/\/www.vbtutor.net\/#website\"},\"datePublished\":\"2016-07-01T08:57:03+00:00\",\"dateModified\":\"2017-10-06T13:43:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vbtutor.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using SQL Queries in Visual Basic 6\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vbtutor.net\/#website\",\"url\":\"https:\/\/www.vbtutor.net\/\",\"name\":\"Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB\",\"description\":\"Start learning Visual Basic from beginner to advanced. Includes VB.NET, VBA, and classic VB tutorials for students and professionals.\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d\",\"name\":\"Liew Voon Kiong\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vbtutor.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/298e9b7c976f23b8bb0deac1079900704b531945d53dab6cda022294a3dda3d4?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/298e9b7c976f23b8bb0deac1079900704b531945d53dab6cda022294a3dda3d4?s=96&d=identicon&r=g\",\"caption\":\"Liew Voon Kiong\"},\"url\":\"https:\/\/www.vbtutor.net\/index.php\/author\/ajt7051vbt\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/","og_locale":"en_US","og_type":"article","og_title":"Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB","og_description":"After creating a database in Visual Basic 6. we can write code to allow the user to \u00a0to search for a certain information using SQL query. SQL stands for Structures Query Language. Using SQL keywords, we are able to select specific information to be displayed based on certain criteria. The syntax of a SQL is &hellip; Continue reading Using SQL Queries in Visual Basic 6","og_url":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/","og_site_name":"Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB","article_publisher":"https:\/\/www.facebook.com\/Vbtutor","article_published_time":"2016-07-01T08:57:03+00:00","article_modified_time":"2017-10-06T13:43:56+00:00","author":"Liew Voon Kiong","twitter_card":"summary_large_image","twitter_creator":"@liewvk","twitter_site":"@liewvk","twitter_misc":{"Written by":"Liew Voon Kiong"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#article","isPartOf":{"@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/"},"author":{"name":"Liew Voon Kiong","@id":"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d"},"headline":"Using SQL Queries in Visual Basic 6","datePublished":"2016-07-01T08:57:03+00:00","dateModified":"2017-10-06T13:43:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/"},"wordCount":85,"articleSection":["Latest News"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/","url":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/","name":"Using SQL Queries in Visual Basic 6 - Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB","isPartOf":{"@id":"https:\/\/www.vbtutor.net\/#website"},"datePublished":"2016-07-01T08:57:03+00:00","dateModified":"2017-10-06T13:43:56+00:00","author":{"@id":"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d"},"breadcrumb":{"@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vbtutor.net\/index.php\/2016\/07\/01\/using-sql-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vbtutor.net\/"},{"@type":"ListItem","position":2,"name":"Using SQL Queries in Visual Basic 6"}]},{"@type":"WebSite","@id":"https:\/\/www.vbtutor.net\/#website","url":"https:\/\/www.vbtutor.net\/","name":"Learn Visual Basic Programming \u2013 VB.NET, VBA &amp; Classic VB","description":"Start learning Visual Basic from beginner to advanced. Includes VB.NET, VBA, and classic VB tutorials for students and professionals.","inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.vbtutor.net\/#\/schema\/person\/01c0e3de22b7692f291440df0ef6601d","name":"Liew Voon Kiong","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vbtutor.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/298e9b7c976f23b8bb0deac1079900704b531945d53dab6cda022294a3dda3d4?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/298e9b7c976f23b8bb0deac1079900704b531945d53dab6cda022294a3dda3d4?s=96&d=identicon&r=g","caption":"Liew Voon Kiong"},"url":"https:\/\/www.vbtutor.net\/index.php\/author\/ajt7051vbt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/posts\/8405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/users\/23013"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/comments?post=8405"}],"version-history":[{"count":1,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/posts\/8405\/revisions"}],"predecessor-version":[{"id":8406,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/posts\/8405\/revisions\/8406"}],"wp:attachment":[{"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/media?parent=8405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/categories?post=8405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vbtutor.net\/index.php\/wp-json\/wp\/v2\/tags?post=8405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}