{"id":26456,"date":"2023-05-09T21:27:35","date_gmt":"2023-05-09T14:27:35","guid":{"rendered":"https:\/\/tom.ji42.com\/?p=26456"},"modified":"2023-05-09T21:27:35","modified_gmt":"2023-05-09T14:27:35","slug":"vfox-sql-connect","status":"publish","type":"post","link":"https:\/\/tom.tomwork.net\/?p=26456","title":{"rendered":"vfox – sql connect"},"content":{"rendered":"
    \n
  1. \n
    sqlhanddle=”Driver={Mysql ODBC 3.51 Driver};dsn=hosxp;Server=localhost;Uid=sa;Pwd=sa;Database=hos”<\/div>\n<\/li>\n
  2. \n
    sqlcondb=SQLSTRINGCONNECT(sqlhanddle)<\/div>\n<\/li>\n
  3. \n
    ?sqlcondb<\/div>\n<\/li>\n
  4. \n
    IF\u00a0sqlcondb\u00a0>\u00a00<\/div>\n<\/li>\n
  5. \n
    =\u00a0SQLEXEC(sqlcondb,’select\u00a0*\u00a0from\u00a0patient limit\u00a0100′\u00a0,’patient’)<\/div>\n<\/li>\n
  6. \n
    =\u00a0SQLEXEC(sqlcondb,’select\u00a0*\u00a0from\u00a0ovst limit\u00a0100′\u00a0,’ovst’)<\/div>\n<\/li>\n
  7. \n
    SELECT\u00a0*\u00a0from\u00a0\u00a0patient\u00a0INTO\u00a0CURSOR\u00a0cursor1<\/div>\n<\/li>\n
  8. \n
    SELECT\u00a0cursor1<\/div>\n<\/li>\n
  9. \n
    BROWSE<\/div>\n<\/li>\n
  10. \n
    =\u00a0SQLDISCONNECT(sqlcondb)<\/div>\n<\/li>\n
  11. \n
    ELSE<\/div>\n<\/li>\n
  12. \n
    =\u00a0MESSAGEBOX(“no”,0)<\/div>\n<\/li>\n
  13. \n
    ENDIF<\/div>\n<\/li>\n
  14. \n
    RETURN<\/div>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    sqlhanddle=”Driver={Mysql ODBC 3.51 Driver};dsn=hosxp;Server=localhost;Uid=sa;Pwd=sa;Database=hos” sqlcondb=SQLSTRINGCONNECT(sqlhanddle) ?sqlcondb IF\u00a0sqlcondb\u00a0>\u00a00 =\u00a0SQLEXEC(sqlcondb,’select\u00a0*\u00a0from\u00a0patient limit\u00a0100′\u00a0,’patient’) =\u00a0SQLEXEC(sqlcondb,’select\u00a0*\u00a0from\u00a0ovst limit\u00a0100′\u00a0,’ovst’) SELECT\u00a0*\u00a0from\u00a0\u00a0patient\u00a0INTO\u00a0CURSOR\u00a0cursor1 SELECT\u00a0cursor1 BROWSE =\u00a0SQLDISCONNECT(sqlcondb) ELSE =\u00a0MESSAGEBOX(“no”,0) ENDIF RETURN<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[13],"tags":[],"class_list":["post-26456","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-6SI","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/26456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=26456"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/26456\/revisions"}],"predecessor-version":[{"id":26457,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/26456\/revisions\/26457"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=26456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=26456"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=26456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}